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