Return blank instead of 0

[GingaNinga]

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)

 

[Fluff]

How about

=IFERROR(1/(1/SUM(AH7:AJ7)),"")

 

[GingaNinga]

How about

=IFERROR(1/(1/SUM(AH7:AJ7)),"")

It works to return blank value - but also makes the 0 on row 4 blank which should stay as 0.

 

[Fluff]

What is the formula in AH7:AJ7 & do you need it, or is it just helper columns?

 

[GingaNinga]

What is the formula in AH7:AJ7 & do you need it, or is it just helper columns?

The formulas are:
AH7 =IF(AA7="N/A","",IF(AA7="YES",1,0))
AI7 =IF(AB7="N/A","",IF(AB7="YES",1,0))
AJ7 =IF(AC8="N/A","",IF(AC8="YES",1,0))

 

[Fluff]

Thanks for that, can you also answer my other question?

 

[Fluff]

How about

=IF(CONCAT(AH7:AJ7)="","",SUM(AH7:AJ7))

 

[GingaNinga]

Thanks for that, can you also answer my other question?

Yes, They are just helper columns.

 

[GingaNinga]

How about

=IF(CONCAT(AH7:AJ7)="","",SUM(AH7:AJ7))

Perfect!!! That worked.

Thank you so much for your help

 

[Fluff]

You're welcome & thanks for the feedback.