I am wanting to create an IF function in excel
May-Jul Aug-Oct Nov-Jan Feb-April
Q1 Q2 Q3 Q4
12 2 8 5
Total 12 2 8 5
Cumul 12 14 22 27
I have another cell which contains the date, and below it another which details the fiscal quarter. What I would like is for there to be a cell that will have the cumulative totals of the quarters in the table above, depending on the fiscal quarter of TODAY.