# I need help with a SUM formula for multiple columns.

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?

• ✭✭✭✭✭✭

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. 😎

• ✭✭✭✭✭✭

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. 😎

• 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!