• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

Sumproduct formula

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.
1 Solution
barry houdiniCommented:
If you want to use A2 and B2 try this version


although in Excel 2007 I would prefer SUMIFS like this


regards, barry
route217Author Commented:
Thanks barry
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now