<div>
or<br />
<br />
=SUMPROCUCT(SUMIFS('all deals'!I:I,'all deals'!E:E,{&quot;Commit&quot;,&quot;Upsi<wbr />de&quot;},'all deals'!K:K,&quot;Civilian&quot;)
</div>


or

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

<div>
<div class="content wysiwyg-content">
I have the following formula that works<br />
<br />
=SUMIFS('all deals'!I:I,'all deals'!E:E,&quot;Commit&quot;,'all deals'!K:K,&quot;Civilian&quot;)<br />
<br />
But I need it to sum if E:E = Commit or Upside
</div>
</div>


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

Change &quot;or&quot; to a formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Change &quot;or&quot; to a formula

Change "or" to a formula