COUNTIF Function Formula Question
On Nov 3, 4:25*pm, Mike H wrote:
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((Mas*ter!F1:F25="SS")*(ISNUMB ER(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- Hide quoted text -
- Show quoted text -
This is apparently the formula to use. Three people suggestioned the
same or similar type formulas. Thank you very much for your reply.
|