Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on averaging function
"Dave Thomas" wrote...
You missed the point entirely. You should have looked at the original message. .... I did. The OP's process is flawed if future months contain 0s rather than are blank. That should be corrected by making those cells contain nothing or "", which AVERAGE automatically skips. So what's the correct answer if any of the OP's HISTORICAL months contain 0s? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on averaging function
Address your concerns to the OP not me
I gave the OP what the OP wanted. Nothing more, nothing less. It's the OP's responsibility to know his data, not mine. It is none of my business what the purpose of the OP's data is or how he uses it Once again, you seem to be the type of person to blame the messenger for the message. "Harlan Grove" wrote in message ... "Dave Thomas" wrote... You missed the point entirely. You should have looked at the original message. ... I did. The OP's process is flawed if future months contain 0s rather than are blank. That should be corrected by making those cells contain nothing or "", which AVERAGE automatically skips. So what's the correct answer if any of the OP's HISTORICAL months contain 0s? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for conditional averaging or "Averageifs" function for | Excel Worksheet Functions | |||
Looking for conditional averaging or "Averageifs" function for | Excel Worksheet Functions | |||
Looking for conditional averaging or "Averageifs" function for '02 | Excel Worksheet Functions | |||
Averaging function is pulling back a zero in Excel | Excel Discussion (Misc queries) | |||
Averaging function | Excel Discussion (Misc queries) |