View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
 
Posts: 740
Default help on averaging function

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