# Column with a running total by location

Options

I have a column for Address, City, and State. When entering data I am able to get a column that will count the total for each, but I want to add a column that shows the running total for each.

For example in row 1 I enter data for location x the running total would show 1. Then in rows 2 and 3 I enter data for location y the running total should who 1 in row 2 and 2 in row 3.

Tags:

Options

Hi Paul,

This is the formula I have to give me the total per location =SUMIFS(Helper:Helper, [Address / Location]:[Address / Location], [Address / Location]1)

I am okay with it always showing the total regardless of when you enter in the data, was just trying to get the running total.

Thanks,

• ✭✭✭✭✭✭
Options

Ok. To get a running total we would just adjust the ranges to look from row 1 to the current row instead of the entire column.

• ✭✭✭✭✭✭
Options

Can you provide your existing formula that gives you the total count. It should only require some minor tweaks, but I'd like to see it first to make sure.

Options

Hi Paul,

This is the formula I have to give me the total per location =SUMIFS(Helper:Helper, [Address / Location]:[Address / Location], [Address / Location]1)

I am okay with it always showing the total regardless of when you enter in the data, was just trying to get the running total.

Thanks,

• ✭✭✭✭✭✭
Options

Ok. To get a running total we would just adjust the ranges to look from row 1 to the current row instead of the entire column.

• Options

Thanks Paul, really appreciate the help!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!