# Average List of Data - Excluding Zero's

#### danbrassard

##### New Member
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.

Thanks,

Dan

### 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
<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
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")

#### danbrassard

##### New Member
Thanks for your help, worked perfectly!

Replies
3
Views
81
Replies
24
Views
740
Replies
10
Views
101
Replies
5
Views
45
Replies
1
Views
48