Bonnie,

Try this but because you are using full columns it will be slow. I would
recommend you shorten the range to something more practical.

=SUMPRODUCT((Master!F:F="WW")*(ISNUMBER(Master!O:O )))+SUMPRODUCT((Master!F:F="SS")*(ISNUMBER(Master! O:O)))

with shortened ranges

=SUMPRODUCT((Master!F1:F25="WW")*(ISNUMBER(Master! O1:O25)))+SUMPRODUCT((Master!F1:F25="SS")*(ISNUMBE R(Master!O1:O25)))

Another point to note is there is no ISDATE worksheet function in Excel so
this looks for a number on col O

Mike


"Bonnie" wrote:

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