Formulas

[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

 

[LaShon]

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?

 

[Leo Heuser]

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.