I need help with a SUM formula for multiple columns.

SLloyd

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?

Frank S.

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

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.

SLloyd

Worked like a charm! Thank you Frank!