Forum Discussion

FFOL8629's avatar
FFOL8629
Copper Contributor
Jun 01, 2023

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, 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

    • FFOL8629's avatar
      FFOL8629
      Copper Contributor
      thank you, i tried it and it didn't work.


      I should mention that C4:I4 are pick from drop down list.
      • FFOL8629 

        In addition, it doesn't matter cell value was entered manually or taken from formula/drop down list.

Resources