I am trying to do the following:

Issue- If B1:B50=Yes and D1:D50=(A specific name) then sum all totals
(Dollar Amounts) in C1:C50 where both of these conditions are true. Can
anyone help. Here is the forumula that I am currently doing, but my result
is always the $VALUE! error.

=SUM(IF(B1:B50=Y*D1:D50=(Specific Name),N6:N45,0))