Solved

Sumproduct formula

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 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