Column with a running total by location

Eric Hornyak

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.

Eric Hornyak

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,

Paul Newcome

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.

=SUMIFS(Helper$1:Helper@row, [Address / Location]$1:[Address / Location]@row, [Address / Location]@row)

Paul Newcome

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.

Eric Hornyak

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,

Paul Newcome

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.

=SUMIFS(Helper$1:Helper@row, [Address / Location]$1:[Address / Location]@row, [Address / Location]@row)

Eric Hornyak

Thanks Paul, really appreciate the help!

Paul Newcome

Happy to help. 👍️