Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
YTD average - How do I create a formula?
Hi!
One way: Entered as an array using the key combo of CTRL,SHIFT,ENTER: =AVERAGE(IF(B1:B5<0,B1:B5)) Biff "Dana" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
YTD average - How do I create a formula?
"Dana" wrote:
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 If you don't like working with array formulas, you could do the following: =SUMIF(A1:A4,"<0")/COUNTIF(A1:A4,"<0") But I wonder why you think ignoring zero months gives you the YTD average. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a moving average in Excel? | Excel Discussion (Misc queries) | |||
Formula for determing average based on weighting | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How do I create a 26 'tier' IF formula? | Excel Discussion (Misc queries) | |||
How to create specific formula | Excel Worksheet Functions |