<div>
I figured it out. &nbsp;I ended up using a sum array function. &nbsp;<br />
<br />
=SUM(('Sheet2 Comp'!$A$2:$A$121=$A3)*('S<wbr />heet2 Comp'!$C$2:$C$121=$C3)*('S<wbr />heet2 Comp'!$D1:$AP1&gt;=D$1)*('She<wbr />et2 Comp'!$D1:$AP1&lt;=D$1)*'Shee<wbr />t2 Comp'!D2:AP121)<br />
<br />
Not pretty but it's almost there.
</div>


I figured it out.  I ended up using a sum array function.  

=SUM(('Sheet2 Comp'!$A$2:$A$121=$A3)*('Sheet2 Comp'!$C$2:$C$121=$C3)*('Sheet2 Comp'!$D1:$AP1>=D$1)*('Sheet2 Comp'!$D1:$AP1<=D$1)*'Sheet2 Comp'!D2:AP121)

Not pretty but it's almost there.

<div>
you could have easily get this done by SUMIFS. &nbsp; currently you are using SUM with array which is much slower in calculation and requires control shift enter
</div>


you could have easily get this done by SUMIFS.   currently you are using SUM with array which is much slower in calculation and requires control shift enter

<div>
How could I get it done in sumifs?
</div>


<div>
<div class="content wysiwyg-content">
Hello, I am trying to set up a sumif involving multiple columns for the sum and multiple checks but I keep on getting a #Value!.<br />
<br />
Here's the formula I'm using.<br />
=SUMIFS('Sheet2 Comp'!D:F,'Sheet2 Comp'!A:A,A:A,'Sheet2 Comp'!C:C,C:C)<br />
<br />
Thank you for your help.
</div>
</div>


Hello, I am trying to set up a sumif involving multiple columns for the sum and multiple checks but I keep on getting a #Value!.

Here's the formula I'm using.
=SUMIFS('Sheet2 Comp'!D:F,'Sheet2 Comp'!A:A,A:A,'Sheet2 Comp'!C:C,C:C)

Thank you for your help.

SUMIFS Involving Multiple Columns

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