| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Obtain a Year to Date result without all cells of data being fille
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Due Date with year using IF for several cells | Excel Worksheet Functions | |||
| Obtain Easter date? | Excel Worksheet Functions | |||
| Work out Credit card Payments to obtain an end date | Excel Discussion (Misc queries) | |||
| remove a year from date value in mulitple cells | Excel Worksheet Functions | |||
| Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
Threaded Mode
