Error Message #Value when using Sumif(indirect) with nested If statements

[mkelly1313]

I get an error message #VALUE when the cell that is suppose have the "x" is left blank. If the cell is marked "x" the formula works.

Here is the formula

=SUM(SUMIF(INDIRECT("'"&Data!G7&"'!C9:C20"),A8,IF(INDIRECT("'"&Data!G7&"'!$F$5")="x",INDIRECT("'"&Data!G7&"'!F9:F20"),"")))

 

[yky]

if the cell isn't marked with an "x", the if statement returns "". Sumif doesn't like that. That's why you get an error message. Maybe you can wrap the formula with another IF to check for "x" first. If the cell is not marked with an "x", return "", else, return "SUM(SUMIF......".