What do you mean by result? what is the formula that you are using?


"bdamin" wrote in message
...
I need to obtain a YTD result at the end of every month. I can not get
that result without temporarily deleteing the cells that do not yet have
data
in them. (These cells refer back to other calculations in the workbook).
Is there anyway to have the YTD calculate with the data that is present
and
ignore the unfilled data and then automatically pickup the upcoming months
when they have data?
Jan-08 54% Jan-08 54%
Feb-08 89% Feb-08 89%
Mar-08 82% Mar-08 82%
Apr-08 80% Apr-08 80%
May-08 0% May-08
Jun-08 0% Jun-08
Jul-08 0% Jul-08
Aug-08 0% Aug-08
Sep-08 0% Sep-08
Oct-08 0% Oct-08
Nov-08 0% Nov-08
Dec-08 0% Dec-08
YTD #DIV/0! YTD 73%
no result result