Identifying trends with =countif?

I have a drop down list of about five hundred items that my four vendors can select from. I'm trying to track trends of frequent selections, such as the top five things + how many times it's been selected within 30 days + who has selected what.

I've used =COUNTIFS(Item:Item, "item name", Date:Date, >=TODAY(-30)) in the sheet summary to count specific things on a small scale, but I know there's a solution for large scale data collection that I've overlooked/can't remember.

Could someone point me in the right direction? Thank you!

Find more posts tagged with

Sheets

Accepted answers

All comments

Ramzi K

@Jennifer Castillo

How does the vendor select at item? Is this one item per row? i.e. every time a vendor selects an item, it's a new row in your sheet?

If that's the case, you will need a separate sheet with a row for each item and then use your formula in the second column in that sheet to do your countif on your vendor selection sheet.

I hope that makes sense and helps you. If not, I can put together an example for you.

Cheers,

Ramzi

Jen Castillo

@Ramzi K

Yes! We have our vendors fill out a form which generates a new row in my vendor sheet.

Your answer does make sense!

I've set up a separate sheet with all the choices, and I think I have an idea of what to do next, but any examples you can give would be greatly appreciated.

Thank you!

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.