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.
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.