Formula to sum text and return number
 

I have a column A that has the words "denture" and "partial" and blank cells.
I need a formula that will sum up the number of times "denture" appears in
column A.

Can anyone help?

Formula to sum text and return number
 

Actually you need to COUNT how many times a word occurs.
SUM is a mathematical process
=COUNTIF(A:A,"denture")
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"INTERN" wrote in message
...
I have a column A that has the words "denture" and "partial" and blank
cells.
I need a formula that will sum up the number of times "denture" appears in
column A.

Can anyone help?

Formula to sum text and return number
 

=COUNTIF(A:A,"denture")

Regards,
Paul

--

"INTERN" wrote in message
...
I have a column A that has the words "denture" and "partial" and blank
cells.
I need a formula that will sum up the number of times "denture" appears in
column A.

Can anyone help?