Thank you. But, there are some funny brackets arount the "WW","SS";
is this an array formula? When I typed it in I held down the CTRL and
ALT but I didn't get the brackets as shown in the formula you wrote
out. Please advise.

Bonnie

On Nov 3, 3:52*pm, "Peo Sjoblom" wrote:
Try something like

=SUMPRODUCT((F2:F30={"WW","SS"})*(ISNUMBER(O2:O30) ))

note that unless you have 2007 you would need to specify the range you are
using, also in your example you used F:F and not A:A so I used F as well
whereas you wrote that you were testing column A

--

Regards,

Peo Sjoblom

"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- Hide quoted text -

- Show quoted text -