If statement then Average

R

Renee

I have a column that has percentages in it; some have #'s great than zero
while others show a zero percentage. I would like my formula to say if the
cell = 0% then don't include in average calculation. Is this possible?

Thank you,
Renee
 
M

Mike H

Hi

=AVERAGE(IF(A1:A10>0,A1:A10,FALSE))

Extend the range to suit. It's an array so commit with
Ctrl+Shift+Enter

Mike
 
D

David Biddulph

=AVERAGE(IF(B1:B100<>0,B1:B100,"")) as an array formula (Control Shift
Enter)
 
R

Renee

Great thanks, that works. But now I have the autofilter on so when I select
one name I want to show the Average for just that name and not the average
for all the names. Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

min,average>0 if 52 cells read zero 2
Average of % in pivot table 1
average with zero 7
If statement with multiple criteria and multiple results 3
Average non-adjacent cells & exclude zeros 3
IF statement 2
Average 10
average of non contigous data to also exclude zeros 14

Top