Average IF Function

S

SandiVaughn

How can you test a range of cells to be greater than or less than another
cell using the average if function?

Ex: =AVERAGEIFS(A1:A4,A1:A4,"A6",A1:A4,"A7")

Keep getting the #DIV/0! error!

HELP!!!!! Thank you!
 
A

Ashish Mathur

Hi,

See if it works by removing the double quotes. Else, try this

=sumproduct((A1:A4>=A6)*(A1:A4<=A4)*(A1:A4))/sumproduct((A1:A4>=A6)*(A1:A4<=A4))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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 Question 2
Average formula where blank cells are counted as zeros 4
Compare last digit in 5 cells for match 0
Average cyclic error 5
SMALL function to find X smallest number greater than Y 6
Excel - Averaging 5
I can't reference a cell as the criteria in the AVERAGEIFS functio 2
Varying cell ranges in formulas according to number of cells with certain value 1

Top