Learn how to a build a cloud-first strategyRegister Now

x
Solved

# sumproduct

Posted on 2011-03-07
Medium Priority
236 Views
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!
0
Question by:dddw

LVL 85

Accepted Solution

Rory Archibald earned 2000 total points
ID: 35057689
=SUMPRODUCT(('1st Mailing'!\$D\$2:\$D\$3631=\$A24)*('1st Mailing'!\$J\$2:\$J\$3631=G\$4),'1st Mailing'!\$J\$2:\$J\$3631)
should do it.
0

LVL 3

Expert Comment

ID: 35057714
Can you post a small sample spreadsheet that provides some sample data?

J.
0

Author Comment

ID: 35058066
Great, that worked.  Thank you Rorya!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
###### Suggested Courses
Course of the Month20 days, 15 hours left to enroll