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.

Nic Larsen

Try: =COUNTIFS({ARA routehelpcnt}, FIND(Routes@row, @cell) > 0)

SkiPatrolScott

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.