Forum Discussion

sherilynk's avatar
sherilynk
Copper Contributor
Feb 26, 2022

countif problem

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 

Excel for web

1 Reply

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Feb 26, 2022
    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)?

Resources