I'm working on a spreadsheet given to me by a coworker. The way they put the spreadsheet together makes this a bit difficult.
I threw together a mock up here: http://uploads.im/StKxL.jpg
Basically, I would want E3-E6 summed up in E2, E8-E9 summed up in E7, and so on. However, I only want to do this for data from 2013 and above, with 2012 being left blank. Is there a formula that could easily be supplemented here? I've tried a few if-then formulas, but they either end in everything being summed, or inaccurate calculations.
Thank you
Bookmarks