Conditional Averages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to calculate the average of ONLY the positive numbers from a
column of both positive and negative numbers. I'm sure there's an easy way
to do it, but everything I've tried hasn't worked. Any suggestions greatly
appreciated!

Kris
 
This is an array formula, meaning you commit it with Shift-Ctrl-Enter

=AVERAGE(IF(A1:A10>0,A1:A10))
 
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

Flipping numeric values 3
Conditional sumif? 5
Excel Issue with "Average" showing in Status Bar 2
Average with multiple conditions 4
SUMIF w/multiple conditions 5
1904 negative time 5
Custom Format with multiple conditonals 1
Average function 9

Back
Top