GingaNinga
New Member
 Joined
 Sep 1, 2017
 Messages
 24
 Office Version

 365
 Platform

 Windows
Hello
I have a sum if in 3 columns that looks at the values of other columns, and returns 1 if YES, 0 if NO, and blank if N/A
I need to sum the total of all three of these columns, and return a blank if all three are blank.
In the screenshot below, I would like row 2  column 4 to return a blank value (all other calculations on the other rows are correct)
The current formula in column 4 is: =SUMIF(AH7:AJ7,"<>",AH7:AJ7)
I have a sum if in 3 columns that looks at the values of other columns, and returns 1 if YES, 0 if NO, and blank if N/A
I need to sum the total of all three of these columns, and return a blank if all three are blank.
In the screenshot below, I would like row 2  column 4 to return a blank value (all other calculations on the other rows are correct)
The current formula in column 4 is: =SUMIF(AH7:AJ7,"<>",AH7:AJ7)