He doesn't want to, he mis-transcribed what he was given.

--

HTH

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


"Peo Sjoblom" wrote in message
...
Of if he wants to use it that way he needs to add another IF

=AVERAGE(IF(Data!$C$2:$C$18=B$3,IF(Data!$N$2:$N$18 <"X",Data!$J$2:$J$18)))


--

Regards,

Peo Sjoblom

"Bob Phillips" wrote in message
...
Your formula was

=AVERAGE(IF(Data!$C$2:$C$18=B$3,Data!$N$2:$N$18<" X"),Data!$J$2:$J$18))

it should be


=AVERAGE(IF((Data!$C$2:$C$18=B$3)*(Data!$N$2:$N$18 <"X"),Data!$J$2:$J$18))

--

HTH

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


"raspywench"
wrote
in message
...

Hi!

Here it is! I have highlighted where I am trying to place the
formula.

Thanks!


+-------------------------------------------------------------------+
|Filename: Model.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4033 |
+-------------------------------------------------------------------+

--
raspywench

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