Re: Formula to sum text and return number

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



=COUNTIF(A:A,"denture")

Regards,
Paul

--

"INTERN" <INTERN@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DDDB94E2-44BC-4F6A-8E13-0DC9AD022431@xxxxxxxxxxxxxxxx
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?


.