I am totalling up individual weekly sales from one table into a cumulative (running total) table.
I need all cells to = NA() if we are not up to that week-number yet. This is so that the graph doesn't plot the points; excellent graphs treat NA() as empty.
I am currently defaulting the cell to NA() if its value is equal to that of the previous week by doing the following:
In C2
=IF((A2+C1)=C1,NA(),A2+C1)
This, however results in the running total defaulting to NA() if there are no sales in one particular week (A2 in this case would be = 0)
Is there a way to do this without linking live dates into the formulae?
If not, then how do i ask for this;
IF(B1 is equal to or less than this week's week-number,(A2+C1),NA())
Column B in this case is a list of numbers from 1 - 52.
Bookmarks