<div>
Create a list of all the tabnames in your workbook somewhere, select that list and name it by typing a name in the NameBox just to the left, for example <i>SheetNames</i><br />
<br />
Then enter a formula like:<br />
<br />
=SUMPRODUCT(SUMIF(INDIRECT<wbr />(&quot;'&quot;&amp;Sheet<wbr />Names&amp;&quot;'!J<wbr />:J&quot;),&quot;Civi<wbr />lian&quot;,INDI<wbr />RECT(&quot;'&quot;&amp;S<wbr />heetNames&amp;<wbr />&quot;'!M:M&quot;)))<wbr />
</div>


Create a list of all the tabnames in your workbook somewhere, select that list and name it by typing a name in the NameBox just to the left, for example SheetNames

Then enter a formula like:

=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetNames&"'!J:J"),"Civilian",INDIRECT("'"&SheetNames&"'!M:M")))

<div>
all I am looking for is one formula for one column<br />
<br />
sum of all deals column M when all deals column J = civilian
</div>


all I am looking for is one formula for one column

sum of all deals column M when all deals column J = civilian

<div>
isn't it something like this <br />
<br />
=SUMIF(!all dealsJ:J, &quot;Civilian&quot;, !all deals M:M)
</div>


isn't it something like this

=SUMIF(!all dealsJ:J, "Civilian", !all deals M:M)

<div>
<div class="content wysiwyg-content">
I have an excel spreadsheet with multiple tabs. &nbsp;I am working on a tab called summary and I want column C to equal the sum of Tab all deals column M when column J = Civilian
</div>
</div>


I have an excel spreadsheet with multiple tabs.  I am working on a tab called summary and I want column C to equal the sum of Tab all deals column M when column J = Civilian

Excel Lookup Assistance

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