Solved

Sumproduct formula

Posted on 2014-03-05
2
259 Views
Last Modified: 2014-03-05
Hi Experts Excel 2007

Is it possible to make the following part of a sum product formula dynamic..

Formula sumproduct(--($A$2:$A$25="name"),--($B$2:$B$25="name2"),$c$2:$cs25)


Ie the part where you have name and name 2.....so as you scroll down the names in column A and B they change.
0
Comment
Question by:route217
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 39907580
If you want to use A2 and B2 try this version

=SUMPRODUCT(--($A$2:$A$25=A2),--($B$2:$B$25=B2),$C$2:$Cs25)

although in Excel 2007 I would prefer SUMIFS like this

=SUMIFS($C$2:$Cs25,$A$2:$A$25,A2,$B$2:$B$25,B2)

regards, barry
0
 

Author Comment

by:route217
ID: 39907647
Thanks barry
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

685 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