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 formula where blank cells are counted as zeros 4
Average Question 2
Excel - Averaging 5
Coppy formula using OFFSET 4
Average cyclic error 4
I can't reference a cell as the criteria in the AVERAGEIFS functio 2
Finding last cell with a value and then adding to another 2
Count non-contiguous cells where value is greater than 0 2

Top