elwayisgod

<div>
Thank you. &nbsp;My issue was I made a bad assumption on the data on tab 'Expanded Data'. &nbsp;They had two hidden rows where the data resided and I did not see that :). &nbsp;Thanks again!!
</div>


Thank you.  My issue was I made a bad assumption on the data on tab 'Expanded Data'.  They had two hidden rows where the data resided and I did not see that :).  Thanks again!!

<div>
Welcome, glad that was helpful.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


Welcome, glad that was helpful.



----------------------------------------

»bp

<div>
Now back to the client to ask how the values it summed actually got there in the source data. &nbsp;I think they were manually typed in, which then is a whole other ball of yarn to untangle :)
</div>


Now back to the client to ask how the values it summed actually got there in the source data.  I think they were manually typed in, which then is a whole other ball of yarn to untangle :)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Having trouble deciphering what this formula is in layman's terms.<br />
<br />
=-SUMIFS('Expanded Data'!$E:$E,'Expanded Data'!$A:$A,'EO100'!$E$5,'<wbr />Expanded Data'!$B:$B,'EO100'!A361,'<wbr />Expanded Data'!$C:$C,'EO100'!B361)<br />
<br />
Any help deciphering is apprecaiated greatly.
</div>
</div>


Hi,

Having trouble deciphering what this formula is in layman's terms.

=-SUMIFS('Expanded Data'!$E:$E,'Expanded Data'!$A:$A,'EO100'!$E$5,'Expanded Data'!$B:$B,'EO100'!A361,'Expanded Data'!$C:$C,'EO100'!B361)

Any help deciphering is apprecaiated greatly.

Need Help:  Excel formula explained

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.