Sumproduct formula

route217
route217 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013
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
route217Junior

Author

Commented:
Thanks barry

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial