Running Count for Rows

I need assistance with a formula:

If 'Request ID#' and 'Day of Contact' have the same info, then calculate the running total in 'Request Count'.

I can't get my formula to work:

=COUNTIFS([Request ID#]:[Request ID#], [Request ID#]@row , [Day of Contact]:[Day of Contact], [Day of Contact]@row , ROW():ROW(), <= ROW()@row )

I manually entered the 'Request Count' to show what it should look like.

Find more posts tagged with

Accepted answers

All comments

Anjanesh Vaidya

Hi @JCrawford,

To calculate the running total, first create a helper column and apply the following formula:
=[Request ID#]@row + [Day of Contact]@row

Then, in the Request Count column, use this formula to get the desired result:

=COUNTIF(Helper$1:Helper@row , Helper@row )

I hope it will help!

Paul Newcome

If you would prefer to use a column formula, first insert an auto-number column (called "Auto" in this example). Formatting for this column doesn't matter.

Then you would insert a text/number column (called "Row" in this example) with this column formula:

=MATCH(Auto@row, Auto:Auto, 0)

Then your running total would be:

=COUNTIFS([Request ID#]:[Request ID#], [Request ID#]@row, [Day of Contact]:[Day of Contact], [Day of Contact]@row, Row:Row, @cell <= Row@row)

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.