Excel spreadsheet for schedule

A

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
 
J

JoeSpareBedroom

A said:
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
Click to expand...


What???
 
S

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.
 
Top