I am wondering how to calculate a cumulative total of data up to the current date of the month in comparison of daily activity in a month to last year.
As the attached example shows, I have two columns, one for the days of the month for this year and one column with the days for last year. I need to compare the total for the days of this year with the total of the days for last year, but only up til the last day of this month which has data entered.
I could create a another column to do this but wanted to calculate it in one cell without creating another column. thanks, johnbtor
Bookmarks