Forum Discussion
Sum columns that contain blank values
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 t...
Anonymous 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
Tweeg
Helper I
Helper IAnonymous 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