Don't think so, OP said ... not an Y in Column M

--

HTH

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


"Biff" wrote in message
...
I'm sure Bob meant:

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

Biff

"Bob Phillips" wrote in message
...
=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