View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default Countif with more than one criteria

This looks like a standard COUNTIF to me

=COUNTIF(A:A,"Novi")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bleeding Maroon" wrote in
message ...
Hi. I need to countif with more than one criteria, how do I do that?
Speadsheet Example:

Column A Column B
Novi 13
Novi 13
North 13


In this example I want to count only when Column A = Novi. Maybe a
different formula is appropriate. Thanks