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

"SandiVaughn" wrote in message
...
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!