Change "or" to a formula

I have the following formula that works

=SUMIFS('all deals'!I:I,'all deals'!E:E,"Commit",'all deals'!K:K,"Civilian")

But I need it to sum if E:E = Commit or Upside
Matt PinkstonAsked:
Who is Participating?
 
Dan CraciunConnect With a Mentor IT ConsultantCommented:
=SUMIFS('all deals'!I:I,'all deals'!E:E,"Commit",'all deals'!K:K,"Civilian") + SUMIFS('all deals'!I:I,'all deals'!E:E,"Upside",'all deals'!K:K,"Civilian")

HTH,
Dan
0
 
NBVCCommented:
or

=SUMPROCUCT(SUMIFS('all deals'!I:I,'all deals'!E:E,{"Commit","Upside"},'all deals'!K:K,"Civilian")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.