Forum Discussion
FFOL8629
Jun 01, 2023Copper Contributor
I need a formula
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...
FFOL8629
Jun 01, 2023Copper Contributor
thank you, i tried it and it didn't work.
I should mention that C4:I4 are pick from drop down list.
I should mention that C4:I4 are pick from drop down list.
SergeiBaklan
Jun 01, 2023Diamond Contributor
In addition, it doesn't matter cell value was entered manually or taken from formula/drop down list.