Sumproduct Q

[John]

I am trying to add up values in Col N14:N20 if the values in Col D1420 is
equal to what is selected from a Drop down menu in D14. I've set the formula
as =SUMPRODUCT((D1420=D14),(N14:N20)) but its not giving me the expected
answer

Thanks

 

[Bob Phillips]

John,

How about

=SUMPRODUCT(--(D1420=D14),N14:N20)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

You may want to look at =sumif(), too.

I am trying to add up values in Col N14:N20 if the values in Col D1420 is
equal to what is selected from a Drop down menu in D14. I've set the formula
as =SUMPRODUCT((D1420=D14),(N14:N20)) but its not giving me the expected
answer

Thanks

 

[Aladin Akyurek]

Invoke a SumIf formula for the calculation you need depends on just one
condition:

=SUMIF(D1420,D14,N14:N20)