David
asked on
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: '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!
=SUMPRODUCT(('1st Mailing'!$D$2:$D$3631=$A24
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great, that worked. Thank you Rorya!
J.