Sum column if another column is not blank

Options

Hello all,

I am trying to create a formula that will only sum budget cells that have a date in another column, if the date column is blank then those budgets would be excluded from the total sum.

I'm having a hard time finding any formula that will work, possibly because these cells are linked from another sheet?

Any help is appreciated.

Thank you!

Tags:

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @nicolehornellp,

    I think this formula will do what you're after:

    =SUMIF([Agency notified of funds transfer]:[Agency notified of funds transfer], <>"", [Total budget]:[Total budget])

    Hope this helps, if there are any problems or you have any questions just post! 😊

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!