View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bonnie Bonnie is offline
external usenet poster
 
Posts: 82
Default COUNTIF Function Formula Question

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