Put this in C8...........

=IF(AND(COUNTIF(F36:F45,"ACS")0,E18="yes"),"Yes", "")

Vaya con Dios,
Chuck, CABGx3



"Shelly" wrote:

I'm trying to do the following:

If E18=Yes
and If any cell F36 through F45 = ACS
Then
c8=Yes
and C9 = Yes

I've tried several things, but cannot get it to work.

Thanks!