May 31 2023 11:53 PM
I need a formula to add the number of days driver is assigned to any given route. I have about 70 different routes. I do not want it to count empty cells of cells containing the words (OFF, VACATION, OUT, PERSONAL) I would like to the number of days to populate in the J column the set up is below.
is the example above the number of day working would add up to 5
Jun 01 2023 01:28 AM
That could be
=COUNTA(C4:I4) - SUM( COUNTIF(C4:I4, {"OFF","VACATION","OUT","PERSONAL"} ) )
Jun 01 2023 08:50 AM
Jun 01 2023 09:03 AM
Jun 01 2023 09:04 AM
In addition, it doesn't matter cell value was entered manually or taken from formula/drop down list.
Jun 01 2023 09:49 AM
Sorry, I didn't catch what your screenshot means. Is most right column generated by FORMULATEXT() or that's what you see after you enter the formula?
What about attached to previous post sample, does it work?
Jun 05 2023 02:00 AM