Home |
Search |
Today's Posts |
#19
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on averaging function
I misread your average. You are correct. But the point stands: it's quite
possible to have positive numbers and negative numbers in an average. "MartinW" wrote in message ... Actually, yes I am assuming that. In practical terms, it wouldn't make sense to average both positive and negative numbers and omit zero. Hi Chip, Where would zero come into the following? 1st Month: $100 loss 2nd Month: $100 loss 3rd Month: $500 profit 3 monthly average profit would be $100 profit. Regards Martin |
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) |