No the brackets are entered physically, no array formula entering and given
your conditions the formula works without taking a whole lot of space

--


Regards,


Peo Sjoblom


"Bonnie" wrote in message
...
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 -