mardi 28 janvier 2020

How do I make a formula with Mulitple IF statements in seperate cells?

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