Search code examples
excelif-statementcell

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"

Tried this SUMIFS:

  SUM.IFS(A36:A160;C36:C160;"Mad";E36:H160;"LAURAS")

But comes up with an error message.

Solution

  • Since E:G are merged the value in only in E. So a simple SUMIFS will work:

    =SUMIFS(A36:A160;C36:C160;"Mad";E36:E160;"*LAURAS*")