dimanche 10 mai 2015

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!!

Aucun commentaire:

Enregistrer un commentaire