Average IF Function

  • Thread starter Thread starter SandiVaughn
  • Start date Start date
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!
 
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
 
Back
Top