Average List of Data - Excluding Zero's

danbrassard

New Member
Joined
Oct 2, 2014
Messages
15
Hello,

I need to average a list of data, F10:F25, and ignore any zeros that may be in the data. Also, there will be positive and negative numbers in the data.

Your HELP is appreciated!!

Thanks,

Dan
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

VBA Geek

MrExcel MVP
Joined
Dec 16, 2013
Messages
2,857
<b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H10</th><td style="text-align:left">=AVERAGEIF(<font color="Blue">F10:F25,"<>0",F10:F25</font>)</td></tr></tbody></table></td></tr></table><br />
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
Hi, Dan.

The newer versions of Excel have an AVERAGEIF function, where you could use =AVERAGEIF(F10:F25,"<>0")

Otherwise, you could use =SUM(F10:F25)/COUNTIF(F10:F25,"<>0")
 

Watch MrExcel Video

Forum statistics

Threads
1,109,543
Messages
5,529,456
Members
409,878
Latest member
DDhol
Top