=AVERAGE(IF((Data!$C$2:$C$181=B$3)*(Data!$M$2:$M$1 81="Y"),Data!J1:J1 80))?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"raspywench" wrote
in message ...

THANKS! :)

So to take it a step further, using the same scenario:

If any cells in Column C = B2, Then average the corresponding cells in
Column J, but only if there is not an Y in Column M

How could that be added into
=AVERAGE(IF(Data!$C$2:$C$181=B$3,Data!J1:J1 80))?

Thank you!


--
raspywench
------------------------------------------------------------------------
raspywench's Profile:
http://www.excelforum.com/member.php...o&userid=20717
View this thread: http://www.excelforum.com/showthread...hreadid=484061