Sum columns that contain blank values

[young351]

I need to sum two columns (WHM Gas + WHM GL) that contain blanks.  I do not want to replace the blanks with zeros, but if a row contains a blank I need to treat it as zero and return the value from the other column:

[Tweeg · Accepted solution]

@young351  This works (not sure if it is the prettiest way to do it):

Sum WH GAS and GL = 

VAR

column11 = IF(ISBLANK(Sheet1[WHM Gas]), 0, Sheet1[WHM Gas])

VAR

column22 = IF(ISBLANK(Sheet1[WHM GL]), 0 , Sheet1[WHM GL])

RETURN

column11 + column22