pdvsa
asked on
Syntax, sumif
Hi, i get a syntax in the below. I added iif(A2 = "","", and not sure where I need the parenthesis. Thank you. The sumif works fine without the addition.
=iif(A2 = "","",(SUMIF(Magal!$F$2:$F $200,Summa ry!A2,Maga l!$D$2:$D$ 200)+SUMIF (Jack!$F$2 :$F$201,Su mmary!A2,J ack!$D$2:$ D$201)+SUM IF(Tony!$F $2:$F$200, Summary!A2 ,Tony!$D$2 :$D$200))
=iif(A2 = "","",(SUMIF(Magal!$F$2:$F
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER