Formulas

  • Thread starter Thread starter Felipe
  • Start date Start date
F

Felipe

LaShon,

You can use COUNTIF.
=COUNTIF(A:A,"C")

where A is the column where your data are.
Or, =COUNTIF(A:A,B1), if B1=C

Regards,
Felipe
 
Now, I need a total count of "C" and "CS" in the same
column. I have tried to figure this one out but, I'm
getting no where. Wouldn't the formula be basically the
same as the first?
 
Two ways:

=SUMPRODUCT(COUNTIF(A:A,{"C","CS"}))

=SUMPRODUCT((A1:A65535={"C";"CS"})+0)

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 
Back
Top