Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging to-date lists???
Hello,
I am trying to average this months list of numbers to-date from the first of the month until now. Since there are no entries in the future cells they are returned as zeros. The average function takes the full month and averages all the numbers in the month, including the zeros values. Is it possible to average the numbers to-date, or do I need to change the future cell values to "no value" IF functions? In either case, does anyone have an example of the equation? Thanks, Paul |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging to-date lists???
Just outsort the 0
=AVERAGE(IF(rng<0,rng)) which is an array formula, commit with Ctrl-Shift-Enter -- __________________________________ HTH Bob "pjroethel" wrote in message ... Hello, I am trying to average this months list of numbers to-date from the first of the month until now. Since there are no entries in the future cells they are returned as zeros. The average function takes the full month and averages all the numbers in the month, including the zeros values. Is it possible to average the numbers to-date, or do I need to change the future cell values to "no value" IF functions? In either case, does anyone have an example of the equation? Thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal by Date and Summary in Lists? | Excel Discussion (Misc queries) | |||
Date lists | Excel Worksheet Functions | |||
NetWorkDays - lists as Date?? | Excel Discussion (Misc queries) | |||
Averaging cells in separate workbooks to make year-to-date average | Excel Discussion (Misc queries) | |||
Averaging data if within a date range | Excel Worksheet Functions |