Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

2010-10-08 Thread C.G.Kumar
200.00 {(9750*6(April-Sep09 months) +9950*6(Sept 09-March 10) = >> 118200.) >> >> >> >> Hope it helps you to solve the crux . >> >> >> >> >> >> Regards, >> >> >> >> C.G.Kumar >> >> AMW-

RE: $$Excel-Macros$$ Conditional Sum or Sumproduct.

2010-10-08 Thread Chandra Gupt Kumar
t: Re: $$Excel-Macros$$ Conditional Sum or Sumproduct. Hi C.G., Could you please elaborate more on what condition you would like to put in here? Regards, Andy On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar wrote: I am looking for conditional sum i.e. sum based on criteria. But neither Sumprod

Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

2010-10-07 Thread Aindril De
Hi C.G., Could you please elaborate more on what condition you would like to put in here? Regards, Andy On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar wrote: > I am looking for conditional sum i.e. sum based on criteria. But neither > Sumproduct nor SUMIFS and Pivot serve the purpose. > > Attached

$$Excel-Macros$$ Conditional Sum or Sumproduct.

2010-10-07 Thread C.G.Kumar
I am looking for conditional sum i.e. sum based on criteria. But neither Sumproduct nor SUMIFS and Pivot serve the purpose. Attached sample file . Hope you will be able to solve the crux. Regards, C.G.Kumar -- --

$$Excel-Macros$$ Conditional Sum or Sumproduct.

2010-10-07 Thread C.G.Kumar
Attached sample file for the problem. Hope somebody among you will be able to solve the crux. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ Conditional Sum or Sumproduct.

2010-10-07 Thread C.G.Kumar
Attached sample file for the problem. Hope somebody among you will be able to solve the crux. Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http