Add "<0" as the 1st criteria.



--
Regards
Dave Hawley
www.ozgrid.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!