Cell Link/Reference - COUNT Question

Good Afternoon all, hoping for some assistance with this formula I am putting together.

For my Number of Dealers Column on Sheet 1, I am trying to get a formula to count the number of Dealer ID's that fall under a certain Market. For Sheet 1 the formula will be looking up cells from Sheet 2. The formula needs to match the Market Column from Sheet 1 and Sheet 2 and count the total number of Dealer ID's for that Market. So for this example the Atlanta Market will have 6 Dealer ID's tied to it. Just a note, Each market will have a different number of dealers.

Any insights, tips or help are welcomed!! Thanks for the time!!

Sheet 1

Sheet 2

Find more posts tagged with

Formulas

Sheet Summary

Countif

Accepted answers

Paul Newcome

You should be able to just count how many cells in the {Market} column have Markets@row.

=COUNTIFS({Market}, @cell = Markets@row)

All comments

Paul Newcome

You should be able to just count how many cells in the {Market} column have Markets@row.

=COUNTIFS({Market}, @cell = Markets@row)

ConnorForm

Hey @Paul Newcome that formula returned a value of 1 for all markets. Some should be more than 1. Such as Atlanta that has 6.

ConnorForm

My apologies @Paul Newcome your formula was correct. Error on my end

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.