Try it like this...

=AVERAGEIFS(A1:A4,A1:A4,"="&A6,A1:A4,"<="&A7)

--
Biff
Microsoft Excel MVP


"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!