FORMULA HELP!!!
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))
|