Sumproduct Q
 

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

Thanks

John,

How about

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

--

HTH

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


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

Thanks

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



John wrote:

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

Thanks

--

Dave Peterson

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

=SUMIF(D14:D20,D14,N14:N20)

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

Thanks