Create Average if value between 2 numbers

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

Guest

I wish to average a column of values if the values in another column (same
rows) are between a specific range, eg > 100 and <200.

Thanks

Todd
 
Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=AVERAGE(IF((A1:A10>100)*(A1:A10<200),B1:B10))

Biff
 
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

Trying to find additional ranges outside of min, max, and average 2
countifs Function not giving desired result with date criteria 2
weighted average from table 3
Average with Conditions 1
Running total over a find number of days 12
How do I set up a formula to give me an average based on IF? 1
lookup (match?) & average 14
Averaging two ranges on the same column (excluding zeros) 2

Back
Top