I need help with a SUM formula for multiple columns.

Options

I am trying to sum multiple columns and can't get the SUM formula to work. I want the TOTAL estimated revenue per month based on each column (Est. Rev 2025 Month).

Here is the formula I am using: =SUM([Est. Rev 2025 MAY]@row+[Est. Rev 2025 JUNE]@row+[Est. Rev 2025 JULY]@row+[Est. Rev 2025 AUGUST]@row+[Est. Rev 2025 SEPTEMBER]@row+[Est. Rev 2025 OCTOBER]@row+[Est. Rev 2025 NOVEMBER]@row+[Est. Rev 2025 DECEMBER]@row+[Est. Rev 2025 JANUARY]@row+[Est. Rev 2025 FEBRUARY]@row+[Est. Rev 2025 MARCH]@row+[Est. Rev 2025 APRIL]@row+)

Can you help me?

Best Answer

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓
    Options

    Greetings @SLloyd

    I want to confirm the request.

    You want to add all of the values from multiple columns.

    If so, the formula would be:

    =Sum([Est. Rev 2025 MAY]:[Est. Rev 2025 MAY],[Est. Rev 2025 JUNE]:[Est. Rev 2025 JUNE],[Est. Rev 2025 JULY]:[Est. Rev 2025 JULY])

    You can add additional columns as needed using the [Cloumn name]:[Cloumn name] format.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

Answers

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓
    Options

    Greetings @SLloyd

    I want to confirm the request.

    You want to add all of the values from multiple columns.

    If so, the formula would be:

    =Sum([Est. Rev 2025 MAY]:[Est. Rev 2025 MAY],[Est. Rev 2025 JUNE]:[Est. Rev 2025 JUNE],[Est. Rev 2025 JULY]:[Est. Rev 2025 JULY])

    You can add additional columns as needed using the [Cloumn name]:[Cloumn name] format.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • SLloyd
    Options

    Worked like a charm! Thank you Frank!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!