<div>
You can simplify your current formula to a single SUMIFS like this:<br />
<br />
=SUM(SUMIFS('all deals'!J:J,'all deals'!G:G,{&quot;Commit&quot;,&quot;Upsi<wbr />de&quot;},'all deals'!M:M,&quot;Civilian&quot;))<br />
<br />
Now you say you need to include when column M = &quot;Civilian&quot;......but that's already included so to add &quot;Forecast&quot; anywhere in column D just add a condition with wildcards like this:<br />
<br />
=SUM(SUMIFS('all deals'!J:J,'all deals'!G:G,{&quot;Commit&quot;,&quot;Upsi<wbr />de&quot;},'all deals'!M:M,&quot;Civilian&quot;,<b>'all deals'!D:D,&quot;*Forecast*&quot;</b>))<br />
<br />
regards, barry
</div>


You can simplify your current formula to a single SUMIFS like this:

=SUM(SUMIFS('all deals'!J:J,'all deals'!G:G,{"Commit","Upside"},'all deals'!M:M,"Civilian"))

Now you say you need to include when column M = "Civilian"......but that's already included so to add "Forecast" anywhere in column D just add a condition with wildcards like this:

=SUM(SUMIFS('all deals'!J:J,'all deals'!G:G,{"Commit","Upside"},'all deals'!M:M,"Civilian",'all deals'!D:D,"*Forecast*"))

regards, barry

<div>
Barry is this what you had in mind?<br />
<br />
=SUMIFS('all deals'!J:J,'all deals'!G:G,{&quot;Commit&quot;,&quot;Upsi<wbr />de&quot;},'all deals'!M:M,&quot;Civilian&quot;) + SUMIFS('all deals'!J:J,'all deals'!D:D,&quot;*Forecast*&quot;,'a<wbr />ll deals'!M:M,&quot;Civilian&quot;)
</div>


Barry is this what you had in mind?

=SUMIFS('all deals'!J:J,'all deals'!G:G,{"Commit","Upside"},'all deals'!M:M,"Civilian") + SUMIFS('all deals'!J:J,'all deals'!D:D,"*Forecast*",'all deals'!M:M,"Civilian")

<div>
<div class="content wysiwyg-content">
Here is my existing formula/lookup that works well.<br />
<br />
=SUMIFS('all deals'!J:J,'all deals'!G:G,&quot;Commit&quot;,'all deals'!M:M,&quot;Civilian&quot;) + SUMIFS('all deals'!J:J,'all deals'!G:G,&quot;Upside&quot;,'all deals'!M:M,&quot;Civilian&quot;)<br />
<br />
I also need to include from &quot;all deals&quot; when column M=&quot;Civilian&quot; and column D includes somewhere in the string the word &quot;forecast&quot;
</div>
</div>


Here is my existing formula/lookup that works well.

=SUMIFS('all deals'!J:J,'all deals'!G:G,"Commit",'all deals'!M:M,"Civilian") + SUMIFS('all deals'!J:J,'all deals'!G:G,"Upside",'all deals'!M:M,"Civilian")

I also need to include from "all deals" when column M="Civilian" and column D includes somewhere in the string the word "forecast"

Modifying an existing excel formula/ookup with more

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