Count Check Box with added Sum Formula
=COUNTIF(Route:Route, ISTEXT(@cell)) - [Non Route Entries]#
My current machine will not allow a PIC to be included. The above formula works, but I need to subtract certain entries that are not "routes", hence the [Non Route Entries]#
This is counting the number of routes patrollers go on during an avalanche cycle. However often the route sheet is pre-populated or a route does not get skied and remains on the sheet. My solution is to add if checked to the [Done] row. I have messed with a bunch of different formulas but no love.....
Help Article Resources
Check out the Formula Handbook template!