Another way ... just keeping the functions consistent:

=Sum(Countif(A1:A100,{"A","B","C"}))

=Countif(A1:A100,"D")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Cindyt" wrote in message
...
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