<div>
Can you post a small sample spreadsheet that provides some sample data?<br />
<br />
J.
</div>


<div>
Great, that worked. &nbsp;Thank you Rorya!
</div>


<div>
<div class="content wysiwyg-content">
I have the below formula to count the records that meet the below sumproduct criteria. &nbsp;Now, I need to sum the value of those specific records in column: '1st Mailing'!$J$2:$J$3631. &nbsp;How can this be done?<br />
<br />
=SUMPRODUCT(('1st Mailing'!$D$2:$D$3631=$A24<wbr />)*('1st Mailing'!$J$2:$J$3631=G$4)<wbr />)<br />
<br />
<br />
Thank you!
</div>
</div>


I have the below formula to count the records that meet the below sumproduct criteria.  Now, I need to sum the value of those specific records in column: '1st Mailing'!$J$2:$J$3631.  How can this be done?

=SUMPRODUCT(('1st Mailing'!$D$2:$D$3631=$A24)*('1st Mailing'!$J$2:$J$3631=G$4))


Thank you!

Can you post a small sample spreadsheet that provides some sample data?

J.

sumproduct

I have the below formula to count the records that meet the below sumproduct criteria.  Now, I need to sum the value of those specific records in column: &#39;1st Mailing&#39;!$J$2:$J$3631.  How can this be done?

=SUMPRODUCT((&#39;1st Mailing&#39;!$D$2:$D$3631=$A24)*(&#39;1st Mailing&#39;!$J$2:$J$3631=G$4))


Thank you!

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