<div>
I believe adding 1 to the first formula will give you the same result<br />
<br />
=SUMPRODUCT((A10=Data!$A$2<wbr />:$A$5000)*<wbr />(F$3=Data!<wbr />$L$2:$L$50<wbr />00)*(1+Dat<wbr />a!$E$2:$E$<wbr />5000)*(Dat<wbr />a!$F$2:$F$<wbr />5000))<br />
<br />
Thomas
</div>


I believe adding 1 to the first formula will give you the same result

=SUMPRODUCT((A10=Data!$A$2:$A$5000)*(F$3=Data!$L$2:$L$5000)*(1+Data!$E$2:$E$5000)*(Data!$F$2:$F$5000))

Thomas

<div>
Thanks barry, I obviously missed a bar there.
</div>


Thanks barry, I obviously missed a bar there.

<div>
<div class="content wysiwyg-content">
This formula gives me the correct answer, but is there a way to simplify it so that I do not have to have 2 SUMPRODUCTS?<br />
<br />
=+SUMPRODUCT((A10=Data!$A$<wbr />2:$A$5000)<wbr />*(F$3=Data<wbr />!$L$2:$L$5<wbr />000)*(Data<wbr />!$E$2:$E$5<wbr />000)*(Data<wbr />!$F$2:$F$5<wbr />000))/+SUM<wbr />PRODUCT((A<wbr />10=Data!$A<wbr />$2:$A$5000<wbr />)*(F$3=Dat<wbr />a!$L$2:$L$<wbr />5000)*(Dat<wbr />a!$F$2:$F$<wbr />5000))<br />
<br />
Thanks
</div>
</div>


This formula gives me the correct answer, but is there a way to simplify it so that I do not have to have 2 SUMPRODUCTS?

=+SUMPRODUCT((A10=Data!$A$2:$A$5000)*(F$3=Data!$L$2:$L$5000)*(Data!$E$2:$E$5000)*(Data!$F$2:$F$5000))/+SUMPRODUCT((A10=Data!$A$2:$A$5000)*(F$3=Data!$L$2:$L$5000)*(Data!$F$2:$F$5000))

Thanks

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.