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