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...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
MVP

FFOL8629 

That could be

=COUNTA(C4:I4) - SUM( COUNTIF(C4:I4, {"OFF","VACATION","OUT","PERSONAL"} ) )
FFOL8629's avatar
FFOL8629
Copper Contributor
Jun 01, 2023
thank you, i tried it and it didn't work.


I should mention that C4:I4 are pick from drop down list.
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Jun 01, 2023

        FFOL8629 

        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?

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 01, 2023

    FFOL8629 

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

Resources