countif problem

%3CLINGO-SUB%20id%3D%22lingo-sub-3217344%22%20slang%3D%22en-US%22%3Ecountif%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217344%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20schedule%20for%20work%20in%20an%20excel%20document.%20It%20has%20been%20working%20great%20previously.%20I%20created%20formulas%20within%20it%20to%20count%20each%20employees%20shift%20numbers%20and%20weekends%20etc.%20It%20has%20been%20working%20great%20but%20this%20time%20I%20have%20one%20employee%20it%20will%20not%20count%3F%26nbsp%3B%20I%20have%20replaced%20the%20formulas%20multiple%20times%20and%20have%20tried%20everything%20I%20can%20think%20of.%20I%20can't%20get%20it%20to%20work.%20Can%20someone%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ESherilyn%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3217344%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217380%22%20slang%3D%22en-US%22%3ERe%3A%20countif%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217380%22%20slang%3D%22en-US%22%3EYou%20might%20double%20check%20the%20employee%20name%20to%20ensure%20it%20actually%20is%20what%20you%20think%20it%20is%20-%20does%20it%20have%20any%20trailing%20spaces%2C%20or%20perhaps%20a%20special%20character%20that%20is%20not%20visible%20(such%20as%20Alt%2BEnter)%3F%3C%2FLINGO-BODY%3E
Occasional Visitor

I have created a schedule for work in an excel document. It has been working great previously. I created formulas within it to count each employees shift numbers and weekends etc. It has been working great but this time I have one employee it will not count?  I have replaced the formulas multiple times and have tried everything I can think of. I can't get it to work. Can someone help me?

 

Thanks,

Sherilyn 

1 Reply
You might double check the employee name to ensure it actually is what you think it is - does it have any trailing spaces, or perhaps a special character that is not visible (such as Alt+Enter)?