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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!