Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on averaging function
Once again, read the original message. In my response to it, I gave Treesy
what Treesy asked for. I don't care about your world of negatives, positives and zeros. So calm down, read the original message and you'll see that my response provided the answer sought. I do not know what Treesy's data is used for nor do I care. "Harlan Grove" wrote in message ... "Dave Thomas" wrote... Are you assuming there are no negative numbers? Treesy doesn't state that there aren't. Treesy just wanted to eliminate 0's and blanks. ... Name a physical, financial or not entirely esoteric process that could produce positive and negative values but not zero values. The point is that if a set of numbers can include positive and negative values, they very likely could also contain legitimate zero values that shouldn't be ignored. As for blanks, they're always ignored unless you mean "" and are (mis)using AVERAGEA instead of AVERAGE or are averaging values through an external reference to a closed workbook. |
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) |