FORMULA HELP!!!

[Guest]

I am trying to do the following:

Issue- If B1:B50=Yes and D150=(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*D150=(Specific Name),N6:N45,0))

 

[Peo Sjoblom]

There are many errors there,

for one thing the arrays should be of the same size


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


entered with ctrl + shift & enter

it can also be written

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

entered normally

 

[PCLIVE]

Try this:

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

HTH,
Paul

 

[Guest]

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

Try this:

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

HTH,
Paul