user4884171
Reputation: 11
What function to use in excel if I would like to sum the cells in which the rows contains the word "confirmed"
I would like to ask if I have cell (A1 to A10) in numbers and the rest of the rows in text that contains
"confirmed",
"confirmed-ALS",
"confirmed-lead".
How do I sum up the cells (A1 to A10) for those cells that contain the text confirmed.
I have this - =IF((C6:Q6)="*Confirmed*", SUM(C3:Q3), ""), but it seems wrong.. hope someone can help..
Thank you!!
Upvotes: 1
Views: 65
Answers (1)
brettdj
Reputation: 55692
from your question i think you want
=SUMIF(C6:Q6,"confirmed*",C3:Q3)
Upvotes: 2
Related Questions
- I need to make special formula to sum only specific cells containing the row with text in Google Sheets
- sum rows if another column has the word 'yes' in it using google sheets
- Formula to check cells and then perform sum action
- How to do a sum of a column if a particular cell of each row matches a particular value?
- Sum all value of row when find a specific word in a column
- SUMIF a cell on the same row, in a certain column, contains a specific text
- how to do a sum if another cell contains a certain 'word
- Sum rows, where other column contains certain phrase
- Sum cells in a column that have a specific value in a cell in their row
- How to sum a number of rows based on a value in a different cell?