This has got to be easier than I'm making it...
I need a formula to sum LAST YEAR'S year-to-date performance, and the formula should reside in cell B16 of the attached.
I only want to calculate cells in column B if there is a number in column C, so that I'm comparing an 'apples to apples' performance. So next week, when I add data in cell C6, the calculation in B16 updates to include sales including cell B6.
I KNOW this isn't as impossible as I seem to be making it. Can anyone help?
Thanks in advance!
Bookmarks