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))

There are many errors there,

for one thing the arrays should be of the same size


=SUM(IF(B1:B50="Y",IF(D1:D50="Specific Name",N1:N50)))


entered with ctrl + shift & enter

it can also be written

=SUMPRODUCT(--(B1:B50="Y"),--(D1:D50="Specific Name"),N1:N50)

entered normally


--
Regards,

Peo Sjoblom





"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))

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))

Thanks for the help. It works like a charm!!!

"PCLIVE" wrote:

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))