GingaNinga
New Member
- Joined
- Sep 1, 2017
- Messages
- 26
- 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)