<div>
<div class="content wysiwyg-content">
Hi Experts Excel 2007<br />
<br />
Is it possible to make the following part of a sum product formula dynamic..<br />
<br />
Formula sumproduct(--($A$2:$A$25=&quot;<wbr />name&quot;),--(<wbr />$B$2:$B$25<wbr />=&quot;name2&quot;),<wbr />$c$2:$cs25<wbr />)<br />
<br />
<br />
Ie the part where you have name and name 2.....so as you scroll down the names in column A and B they change.
</div>
</div>


Hi Experts Excel 2007

Is it possible to make the following part of a sum product formula dynamic..

Formula sumproduct(--($A$2:$A$25="name"),--($B$2:$B$25="name2"),$c$2:$cs25)


Ie the part where you have name and name 2.....so as you scroll down the names in column A and B they change.

Sumproduct 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.