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