AVGIF

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

Guest

I'm looking for a way to get the average of numbers in a column that meet a
certain critiera. For instance, in one column, I will have numbers ranging
from 1 thru 6. I am not interested in having the number 6 averaged into the
total. (In essence 6 is assigned through an option button that really should
be 0 and I don't want zeros included as part of my averaging)
 
=AVERAGE(IF(1-(Range=Exclude),Range))

which must be confirmed with control+shift+enter.

Exclude stands for a number that you want to exlude from the average like 6.
 
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

Average of Day and Time 3
How to count the maximum number flanked by zeros 9
Average non-consecutive cells excluding zero 8
Averaging two ranges on the same column (excluding zeros) 2
Average Ranges of Cells, Return Separate Value for Each Range 5
Average formula works but.... 3
move data from columns to rows 3
Average formula only works partially..... 6

Back
Top