Cumulative sum on Condition (Horizontally) Part-2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top