count individual instances rather than totals

I need help modifying a formula that counts Request ID occurrences. My current formula counts the total number of times each Request ID appears, but I need it to count each individual instance instead.

Current formula:

=COUNTIF([Request ID]:[Request ID], [Request ID]@row )

What it currently does: Counts total occurrences of each Request ID

What I need: Count each individual instance/occurrence of Request IDs

How do I adjust this formula to count individual instances rather than totals?

Find more posts tagged with

Accepted answers

All comments

Cassie L

Hi @JCrawford,

You appear to have that in place with your existing formula — so every time R-260004 is listed for example, it will count occurrences of that within the Request ID column: where you have any occurrence of any Request ID, it will provide the total which is in effect also the number of occurrences.

Correct me if this is not a correct assumption but it sounds like you may be looking for a list / calculation sheet where each ID is listed and then there is a count of how many times the ID @ row occurs

(perhaps for use on a Dashboard widget?)

Example:

R-260001 | 2 occurrences

R-260002 | 3 occurrences

R-260003 | 1 occurrences

R-260004 | 2 occurrences

R-260005 | 2 occurrences

R-260006 | 2 occurrences

etc.

In this case, you may want to consider using a column elsewhere on the sheet (to the left or right) of the dataset you showed so you can have the individual Request IDs listed out in order (as I have below in Individual Request IDs column) and count the occurrences of each without having them repeated in that list (like yours is currently).

If this is not correct, can you help me understand: what would you expect to see under the Request ID column for any of those Request IDs?

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.