Re: Formula to sum text and return number

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

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


.

Relevant Pages

  • Re: Summing data referencing incremental cells
    ... Bernard V Liengme ... remove caps from email ... copy it to D83 and sum C11:C15? ...
    (microsoft.public.excel)
  • Re: Sum multiple colums of data
    ... Bernard V Liengme ... Microsoft Excel MVP ... remove caps from email ... will sum Jan-Mar by looking up "Q1" in row 1. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Add qualifier to andif statement
    ... Bernard V Liengme ... remove caps from email ... I want to sum any Jan1-Jan31 hours for "Bob" ...
    (microsoft.public.excel.newusers)
  • Re: Need help in creating a formula
    ... I can sum these and convert to decimal hours with =SUM*24 ... The result is 22.5 but please note the cell must be formatted General (Excel ... Microsoft Excel MVP ... remove caps from email ...
    (microsoft.public.excel.misc)
  • Re: SUMIFS error
    ... Bernard V Liengme ... remove caps from email ... All I want to do is get a sum of the price column if type=L and agent ...
    (microsoft.public.excel.misc)