Sum if three columns are blank


Trying to write a formula to say if column A + column B and column C are blank sum column D

=SUM(ISBLANK({column A}@row,+ {column B}@row,+{column C}@row, SUM({column D}@row)))

I feel like I'm close but still getting an error

Best Answer

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭
    Answer ✓

    @Connie Cochran Review the syntax to make sure you understand where commas are needed instead of plus signs.

    From your use of { and }, I take it those ranges are cross referenced from another sheet?

    I suggest you try a straightforward SUMIFS:

    = SUMIFS({column D}, {column A}, ="", {column B}, ="", {column C}, ="")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!