One more..............if all you have is a, b, c, d

=COUNTA(A1:A10)-COUNTIF(A1:A10,"d")

=COUNTIF(A1:A10,"d")


Gord Dibben MS Excel MVP

On Tue, 4 Aug 2009 11:27:02 -0700, Cindyt
wrote:

Thank you so much!!!! Works like a charm!!
cindy


"Jacob Skaria" wrote:

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