M
MH
Hi,
In column A i have the month formatted as mmm-yy
In colums B, C, D,E and F I have values for different categories. In some
cells, starting at P4 for example. I would like to get YTD totals for columns
B,C etc. I would like to be able to simply enter my values in B,C, etc and
P4 updates such that when I enter the values for Jan of a new year the YTD
total starts over by itself. Any ideas?
Thanks for the time and effort.
-Matt
In column A i have the month formatted as mmm-yy
In colums B, C, D,E and F I have values for different categories. In some
cells, starting at P4 for example. I would like to get YTD totals for columns
B,C etc. I would like to be able to simply enter my values in B,C, etc and
P4 updates such that when I enter the values for Jan of a new year the YTD
total starts over by itself. Any ideas?
Thanks for the time and effort.
-Matt