I want to make a formula that sums IF C36:C160 = "Text" and if E36:H160 = "Some other text"/2
Hope this makes sense!
-SUM.IF(E36:H160;"*LAURAS*";A36:A160)/2
basicly this with the added C36:C160="Mad"
Aucun commentaire:
Enregistrer un commentaire