?
Solved

sumproduct

Posted on 2011-03-07
3
Medium Priority
?
238 Views
Last Modified: 2012-05-11
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
Comment
Question by:dddw
3 Comments
 
LVL 85

Accepted Solution

by:
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

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

J.
0
 

Author Comment

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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question