| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
skip 0 average
How do average a colum of numbers? I will ignore the $0 number.
Thank you very much! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
skip 0 average
One way...
Try this array formula** : =AVERAGE(IF(A1:A20<0,A1:A20)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Ken" wrote in message ... How do average a colum of numbers? I will ignore the $0 number. Thank you very much! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
skip 0 average
On 4/23/2010 5:52 PM, Ken wrote:
How do average a colum of numbers? I will ignore the $0 number. Thank you very much! If you have Excel 2007 =AVERAGEIF(A1:A10,"<0") = = = = = = = HTH :) Dana DeLouis |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
skip 0 average
=AVERAGE(IF(A1:A6<0,A1:A6))
ctrl+shift+enter, not just enter "Ken" wrote: How do average a colum of numbers? I will ignore the $0 number. Thank you very much! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
skip 0 average
Non array formula
=SUM(A1:A6)/COUNTIF(A1:A6,"<0") Just press enter "Ken" wrote: How do average a colum of numbers? I will ignore the $0 number. Thank you very much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using IF to skip | Excel Worksheet Functions | |||
| skip errors in an average | Excel Worksheet Functions | |||
| How do I get an average for 5 when I need to skip cells? | Excel Discussion (Misc queries) | |||
| Average/Min column of numbers, but skip 0's and Null's in the form | Excel Worksheet Functions | |||
| Average Column, but Skip Null and 0? | Excel Worksheet Functions | |||
Linear Mode
