Associate a Value to count from multiple entries
SkiPatrolScott
✭✭✭✭
=COUNTIFS({ARA routehelpcnt}, ROUTES@row
The count in the above PIC is generated from the formula above.
This sheet pulls from another sheet, sometimes a patroller will be doing two routes at the same time, so the assignment might be STRAW 1 STRAW 2, in the same cell
I would like to credit STRAW 1 with an additional count and STRAW 2 with an additional count. If I enter as is, neither gets credit.
Answers
-
Try: =COUNTIFS({ARA routehelpcnt}, FIND(Routes@row, @cell) > 0)
-
Find did some interesting things, added counts to some and went to zero on others... Because we have some like JP 1, JP 1L it combined these.. thanks for the idea though.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives