Try this:

=SUMPRODUCT(--(B1:B50="Yes"),--(D1:D50="Specific Name"),C1:C50)

HTH,
Paul

"Bolin" wrote in message
...
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))