hi there,
I am calculating yearly quarter values of from monthly data and I am unable to find the very flexible formula I need. The reason is that I would like my quarter cells to appear next to each other while not disturbing my monthly cells. So I need a formula that looks 3 cells over from the previous one.
Example
Jan Feb Mar Apr May Jun Jul Aug Sept
46 48 58 26 22 35 58 47 68
SUM SUM SUM
Q1 Q2 Q3
152 83 173
Let me know if you need a better explanation. I basically need a formula that skips a known number of cells before recalculating.
Example Attached. I would love for the formulas at the bottom (the CDD data) to move down automatically like the ones in the HDD column have (that was manually done)
Thanks!
|