#1
|
|||
|
|||
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! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving a Long Document | clpix | Word | 1 | 01-14-2010 08:55 PM |
Moving Entire Text | Sleeper | Word | 2 | 01-10-2010 04:40 PM |
Moving from Vista to Windows 7 | zyzzyva57 | Office | 0 | 12-18-2009 04:41 PM |
Range Formula | aleksandr | Excel | 10 | 05-18-2009 12:14 PM |
Moving Items | windsurfer | Outlook | 0 | 12-06-2005 06:36 AM |