cumulative sum formula in excel 2003

[muffinson]

I have a spreadsheet that looks like this



A B C D E F

1 Month ?

2

3 Jan Feb Mar Apr May MTD

4 10 14 15 9 8 ?




I want to have a cumulative sum formula in cell f4, which would add up the figures in row 4 depending on the date I entered in cell B2.


For e.g. if I entered Mar in B1, my MTD figure in F4 would = 39, the Sum of Jan, Feb & Mar.

 

[NBVC]

Like this?

=SUM(A4:INDEX(A4:E4,MATCH(B1,A3:E3,0)))

 

[Domenic]

Try...

=SUM(B4:INDEX(B4:F4,MATCH(B1,B3:F3,0)))

Hope this helps!

 

[muffinson]

Thank YOu

Thank you so much!! it works.... I only wished I understood how but it works....

I'm so happy...