Solved

# Sumproduct formula

Posted on 2014-03-05
254 Views
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
Question by:route217

LVL 50

Accepted Solution

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

ID: 39907647
Thanks barry
0

## Featured Post

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…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.