Column with a running total by location

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.

Find more posts tagged with

Formulas

Accepted answers

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)

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.