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.
route217Asked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
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
 
route217Author Commented:
Thanks barry
0
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.

All Courses

From novice to tech pro — start learning today.