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
Best Answer

You should be able to just count how many cells in the {Market} column have Markets@row.
=COUNTIFS({Market}, @cell = Markets@row)
Answers

You should be able to just count how many cells in the {Market} column have Markets@row.
=COUNTIFS({Market}, @cell = Markets@row)

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.

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

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!