I am creating a spread sheet that has calculations from the raw data that is
entered monthly. The calculation data and some data are then refered to in
seperate tabs that create a dashboard display with appropriate graphs in a
tab. My question is, how do I set up the calculations to only recognize for
the months up to the report date? I have some of the calculations set up to
see 0 as 100% when there are no entries and then when you go to the quarters
and YTD, they all average the dates that do not have data since we have not
gotten to those months yet. I would like to get this set up so that the raw
data can be entered each month from the diffenet groups and I do not have to
reset the calculations to include each new month. It does nothing to show a
YTD total that has 10 months of 100% averaged in.