I am assuming this would check for the whole range and average any
corresponding values in another range?

For example, out of my entire sales report, I would like to average the
PRICE(N7:N81) column only for records that have New York in the
STATE(G7:G81) column...



thanks!

-mek


--
MEK911
------------------------------------------------------------------------
MEK911's Profile: http://www.excelforum.com/member.php...o&userid=27115
View this thread: http://www.excelforum.com/showthread...hreadid=466285