Formula to sum text and return number

I

INTERN

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?
 
B

Bernard Liengme

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