Cumulative sum on Condition (Horizontally) Part-2
 

Hi,
Another help required from the same excel sheet, my sheet goes in the month
format upto "n" (example current month Mar-07), then how to pick up the
values in the financial year (Apr-Mar is a year). The formula
(=SUMPRODUCT(($A$3:$A$5=N3)*($B$1:$I$1<=N1)*(B2:I2 =N2)*($B$3:$I$5))) what i
am using advised by our experts (is caliculating apr 05-mar 07 instead of apr
06-mar 07.
Excuse me if i have not given the scenario exactly.
Thanks to "Toppers", who really helped me in this issue.

Cumulative sum on Condition (Horizontally) Part-2
 

If you have dates (and data) which span more than one year then add an extra
test: you wiil need to give a start and end date.

=SUMPRODUCT(($A$3:$A$5=N3)*($B$1:$I$1=N1)*($B$1:$ I$1<=N2)*(B2:I2=N4)*($B$3:$I$5)))

Where N1 and N2 are your start and end dates, N3=RO1 and N$=Prod 1 (from
earlier example)

"vijaydsk1970" wrote:

Hi,
Another help required from the same excel sheet, my sheet goes in the month
format upto "n" (example current month Mar-07), then how to pick up the
values in the financial year (Apr-Mar is a year). The formula
(=SUMPRODUCT(($A$3:$A$5=N3)*($B$1:$I$1<=N1)*(B2:I2 =N2)*($B$3:$I$5))) what i
am using advised by our experts (is caliculating apr 05-mar 07 instead of apr
06-mar 07.
Excuse me if i have not given the scenario exactly.
Thanks to "Toppers", who really helped me in this issue.

Cumulative sum on Condition (Horizontally) Part-2
 

Thanks once again really worked well.
if you can give me your mail id i will be happy


"Toppers" wrote:

If you have dates (and data) which span more than one year then add an extra
test: you wiil need to give a start and end date.

=SUMPRODUCT(($A$3:$A$5=N3)*($B$1:$I$1=N1)*($B$1:$ I$1<=N2)*(B2:I2=N4)*($B$3:$I$5)))

Where N1 and N2 are your start and end dates, N3=RO1 and N$=Prod 1 (from
earlier example)

"vijaydsk1970" wrote:

Hi,
Another help required from the same excel sheet, my sheet goes in the month
format upto "n" (example current month Mar-07), then how to pick up the
values in the financial year (Apr-Mar is a year). The formula
(=SUMPRODUCT(($A$3:$A$5=N3)*($B$1:$I$1<=N1)*(B2:I2 =N2)*($B$3:$I$5))) what i
am using advised by our experts (is caliculating apr 05-mar 07 instead of apr
06-mar 07.
Excuse me if i have not given the scenario exactly.
Thanks to "Toppers", who really helped me in this issue.