Distinct Count IF or Running Count Total
Good Morning All,
I need a formula to count the running total of the Dealer Names as they appear. The current formula I have in Column 14: =COUNTIFS(Dealer:Dealer, Dealer@row) is showing the total times Dealer Name is referenced. In my situation I would need "TriGreen Equipment - Ag & Turf" is referenced twice but has two different budgets associated with the two. I would like this formula to count the first instance TriGreen Equipment - Ag & Turf as 1 associated with the $4,000 budget and the second as 2 associated with $13,578. Is that possible? There could be more duplicates with different budgets in the future so just want to be able to account for them if I have to reference the same Dealers but different information like budget and other columns that could be added.
Best Answer
-
Hey @ConnorForm,
I would change the range in the first part of the COUNTIF to as follows:
=COUNTIF(Dealer$1:Dealer@row, Dealer@row)
This will make it so the count increments only on previously repeated Dealers.
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Answers
-
Hi @ConnorForm
This should hopefully deliver what you need
=COUNTIFS(Dealer:Dealer, Dealer@row,[Total Budget]:[Total Budget],[Total Budget]@row)
So its only counting instances where the Dealer name and total budget amount matches
Hope that helps
Thanks
Paul
-
Hey @ConnorForm,
I would change the range in the first part of the COUNTIF to as follows:
=COUNTIF(Dealer$1:Dealer@row, Dealer@row)
This will make it so the count increments only on previously repeated Dealers.
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Thanks @bisaacs and @Paul McGuinness both worked!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!