Maybe you should explain hat you are trying to do instead, that formula make
no sense to me,
why are you even trying to include COUNTIF?


--


Regards,


Peo Sjoblom


"M.A.Tyler" <Great Lakes State wrote in message
...
=INDEX(COUNTIF('PAR CALC.'!A3:A133,B3),'PAR
CALC.'!C3:C133,MATCH(Answers!L4,'PAR CALC.'!AV3:AV133,0))

Is this the proper way to nest these two functions? It returns a #REF!
error, but is it due to the formula or the calculation?

Thanks.

M.A.Tyler