Do you mean

=SUMPRODUCT(--(A1:A100={"a","b","c"}))
=COUNTIF(A:A,"d")

If this post helps click Yes
---------------
Jacob Skaria


"Cindyt" wrote:

Hi:
I need to add all business lines - ie. A, B, C, D that are in a column.
A, B, C need to be added together
D needs to be added on it's own. This is what I ultimately need to know:
IF my lines of business are as follows-
a
a
b
c
c
d
d
c
a
Then my first total would be 7 for the a b c's
Then my second total would be 2 for the d's
I am using 2003 version.
Thank you in advance for your help.
Cindy