Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Is there a function for calculating the sum of 2+ COUNT columns?

Topic Labels: Formulas
189 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a two separate Count columns and I’d like to add them together to find the total count. Is this possible?

2 Replies 2

If you’re trying to get the sum for each record individually, that’s

{Count Column 1} + {Count Column 2}

or

SUM({Count Column 1}, {Count Column 2})

If you want the total of all values across all records from both Count Columns, you need to either run a script or link all the records to one common record and use Rollups to do the summing.

Formulas can’t “see” values not attached to the current record, Rollups can’t see values not attached to the current record or linked records.

I used your second formula and it was exactly what I needed - thank you!! :slightly_smiling_face: :pray: