|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 23rd, 2010, 10:52 PM
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
April 23rd, 2010, 11:07 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
skip 0 average
One way...
Try this array formula** : =AVERAGE(IF(A1:A200,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
April 23rd, 2010, 11:17 PM
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
April 23rd, 2010, 11:26 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
skip 0 average
=AVERAGE(IF(A1:A60,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
April 23rd, 2010, 11:28 PM
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
