From: Ken on 23 Apr 2010 17:52 How do average a colum of numbers? I will ignore the \$0 number. Thank you very much! From: T. Valko on 23 Apr 2010 18:07 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 news:96DA8155-CCAD-492F-BCAC-D9E426ABE765(a)microsoft.com...> How do average a colum of numbers? I will ignore the \$0 number. > > Thank you very much! From: Dana DeLouis on 23 Apr 2010 18:17 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 From: Teethless mama on 23 Apr 2010 18:26 =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! From: Teethless mama on 23 Apr 2010 18:28 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!