• Status: Solved
• Priority: Medium
• Security: Public
• Views: 180

# 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,Summary!A2,Magal!\$D\$2:\$D\$200)+SUMIF(Jack!\$F\$2:\$F\$201,Summary!A2,Jack!\$D\$2:\$D\$201)+SUMIF(Tony!\$F\$2:\$F\$200,Summary!A2,Tony!\$D\$2:\$D\$200))
0
pdvsa
1 Solution

Commented:
Surely just IF.....?

=IF(A2="","",SUMIF(Magal!\$F\$2:\$F\$200,Summary!A2,Magal!\$D\$2:\$D\$200)+SUMIF(Jack!\$F\$2:\$F\$201,Summary!A2,Jack!\$D\$2:\$D\$201)+SUMIF(Tony!\$F\$2:\$F\$200,Summary!A2,Tony!\$D\$2:\$D\$200))

and perhaps the first A2 should be Summary!A2?

regards, barry
0

Project financeAuthor Commented:
Perfect.  thank you barry!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.