Hi,

Try this

=sumproduct((isnumber(match(F2:F50,F55:F56,0)))*is number(O2:O50))

F55:F56 contains WW and SS

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Bonnie" wrote in message
...
May I have help with this formula, please. I need to count how many times
"WW" or"SS" are entered in Column F ... AND ... there is a date entered in
Column O on the same Row as the WW or SS appear in Column A.

I got this far: =COUNTIF(Master!F:F,"WW")+COUNTIF(Master!F:F,"SS") ...
but
I don't know how to include the reference to Column O.

By the way, yes, the formula I'm creating is on a separate worksheet than
the reference cells.

Thank you, in advance, for any guidance you can give. Bonnie