Solved

Sumproduct formula

Posted on 2014-03-05
2
257 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

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 demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

840 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