need simplified Cumulative total with if condition

[ganeshm]

Hi all..

i have posted excel file with if condition calculating cumulative total. I request u to assist me in finding out cumulative total with other formula, just in case if i have to use 12 months.

Currently... the excel file holds only 3 months. Formula will be long,if i keep adding months. Kindly, suggest me with other substitute formula for that.


Regards,
ganeshm

 

[Jake Collins]

Dear Ganeshm

For B30 the following forumla should do the trick, it compares the dates in B3 to D3 and if they are less than or equal to the date in B18 then it will add up the corresponding values in row 15.

=SUMIF(B3:D3,"<="&B18,B15:D15)

If you add more months then you'll need to extend the b3:d3 and b15:d15 ranges

 

[ganeshm]

thank you very much.... it works.

regards,

 

[Syedali]

PFA

Another Option

 

[Khalid NGO]

Another way...
=SUMPRODUCT((B3:D3<=B18)*(B15:D15))

@Syedali
I think your formula should be:
=IF(B18=B3,B15,IF(B18=C3,B15+C15,SUM(B15:D15)))

Regards,

 

[Syedali]

Sorry. Corrected file