Posted to microsoft.public.excel.worksheet.functions

Dana

Posts: n/a

YTD average - How do I create a formula?

A column of monthly totals
Jan 400
Feb 800
Mar 0
Apr 0
May 0
Need a simple formula that will return an average on non zero months ie: 600

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
How do I create a moving average in Excel?	SamA	Excel Discussion (Misc queries)	9	January 4th 06 11:17 PM
Formula for determing average based on weighting	John Sullivan	Excel Worksheet Functions	2	December 16th 05 08:21 AM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
How do I create a 26 'tier' IF formula?	callum	Excel Discussion (Misc queries)	5	October 23rd 05 04:48 PM
How to create specific formula	STS	Excel Worksheet Functions	4	May 2nd 05 01:44 AM

All times are GMT +1. The time now is 06:16 AM.

About Us

"It's about Microsoft Excel"