I need a formula

Question

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

sergeibaklan · Answer

FFOL8629&nbsp;
That could be
=COUNTA(C4:I4) - SUM( COUNTIF(C4:I4, {"OFF","VACATION","OUT","PERSONAL"} ) )

ffol8629 · Answer

thank you, i tried it and it didn't work.I should mention that C4:I4 are pick from drop down list.

sergeibaklan · Answer

FFOL8629&nbsp;
Could you please check if attached file works in your environment. It has nothing but

sergeibaklan · Answer

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

ffol8629 · Answer

SergeiBaklan&nbsp;&nbsp;&nbsp;

Forum Discussion

I need a formula

Resources