Home |
Search |
Today's Posts |
#20
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Martin,
the sample is great, yet if there is no category for a *0* (b/w loss and profit), then there will be be no existing *0* as a Data... kinda llike..give me *0* but its not categorized in the Data list***then what is the *0* data stands for? <g -- regards, driller ***** - dive with Jonathan Seagull "MartinW" wrote: 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 | |
|
|
![]() |
||||
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) |