help on averaging function

#23

Posted to microsoft.public.excel.worksheet.functions

MartinW

external usenet poster

Posts: 860

help on averaging function

Yeah.
The only formula to work correctly in this situation is a simple
=AVERAGE(A1:A12)
With a caveat that zero values MUST be shown as zero and not blank
and blank values MUST be shown as blank and not zero.

Month 1. $200 Loss
Month 2. $100 Loss
Month 3. $0 Broke even
Month 4. $200 Profit
Month 5. $400 Profit.
Month 6. ""
Month 7. ""
Month 8. ""
etc.

Regards
Martin

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looking for conditional averaging or "Averageifs" function for	threee11	Excel Worksheet Functions	0	November 30th 06 05:14 PM
Looking for conditional averaging or "Averageifs" function for	threee11	Excel Worksheet Functions	0	November 30th 06 05:10 PM
Looking for conditional averaging or "Averageifs" function for '02	Dave F	Excel Worksheet Functions	0	November 30th 06 04:59 PM
Averaging function is pulling back a zero in Excel	Thennessee	Excel Discussion (Misc queries)	3	October 11th 05 03:14 AM
Averaging function	Sarah	Excel Discussion (Misc queries)	0	January 18th 05 04:09 PM

All times are GMT +1. The time now is 02:48 PM.

Menu

About Us