[A]

I need a formula that will total multiple text in the same column. I need to
add all D's, G' and H's in the same set of cells, what formula can I use?
A

[JoeSpareBedroom]

"A" wrote in message
...
I need a formula that will total multiple text in the same column. I need
to
add all D's, G' and H's in the same set of cells, what formula can I use?
A


What???

[ShaneDevenshire]

Hi A,

I presume you mean count the D, G's and H's.

Suppose your data is in column A1:A22, enter D, G, H in cells F1:F3. Then
enter the following formula:

=SUMPRODUCT(COUNTIF(A1:A22,F1:F3))

--
Cheers,
Shane Devenshire
Microsoft Excel MVP
Join http://setiathome.berkeley.edu/ and download a free screensaver and
help search for life beyond earth.

"A" wrote:

I need a formula that will total multiple text in the same column. I need to
add all D's, G' and H's in the same set of cells, what formula can I use?
A