Average If greater then )%

  • Thread starter Thread starter deann1584
  • Start date Start date
D

deann1584

Is it possible to have an average for a column of percentages onl
including percentages greater then zero
 
Hi
try the following array formula (entered with cTRL+SHIFT+ENTER):
=AVERAGE(IF(A1:A100>0,A1:A100))
 
You must log in or register to reply here.

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

Excel Average dates help 0
Counting a range of cells 2
Nested IF Statements 6
Averaging numbers in a column while excluding blank spaces and zer 4
played win percentage for averages for a league. 1
Average If 3
Average % - this should be easy? 2
Help with percentages 1

Back
Top