Average If greater then )%

D

deann1584

Is it possible to have an average for a column of percentages onl
including percentages greater then zero
 
F

Frank Kabel

Hi
try the following array formula (entered with cTRL+SHIFT+ENTER):
=AVERAGE(IF(A1:A100>0,A1:A100))
 

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

Resource name inside resource sheet: per person, work per hours per week 0
Calculating an average of data between two dates 1
Need help with average/lookup formula 2
Not having luck with any examples of averaging... 2
Conditional Formatting 7
averaging a range 3
Cell data entering slow! 0
Nested IF Statements 6

Top