Counting records

Hi,

I'm creating a form to capture data that includes the name of the person completing the form.

The info on the form will then be reviewed and categorised.

What I want to do is count up the number of times a named person appears and also do this by the various categories.

The problem I have is that, whist I know the categories, the names can be anything. I can use COUNTIFS, but as I will not know the names beforehand I'm a bit stuck?

Is there a formula or function to do this?

Thanks for any help.

HS.

Find more posts tagged with

Formulas

Accepted answers

Head Scratch

Just found the solution via Mr Newcombe

Here is the link

https://community.smartsheet.com/discussion/66905/counting-duplicates-using-a-formula

I've used this in my test

=COUNTIFS(Name:Name, Name@row, Category:Category, Category@row)

All comments

Head Scratch

Just found the solution via Mr Newcombe

Here is the link

https://community.smartsheet.com/discussion/66905/counting-duplicates-using-a-formula

I've used this in my test

=COUNTIFS(Name:Name, Name@row, Category:Category, Category@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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.