View Single Post
  #22  
Old July 18th, 2007, 12:50 AM posted to microsoft.public.excel.worksheet.functions
Dave Thomas
external usenet poster
 
Posts: 146
Default help on averaging function

To extend your example:

Month 1. $200 Loss
Month 2. $100 Loss
Month 3. $0 Broke even
Month 4. $200 Profit
Month 5. $400 Profit.

Average Profit (including 0), $60, (excluding 0), $75.

"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