Forum Discussion
Using LEN function for letter by itself, not in a word or initials
I am working on a work schedule in excel for hospital NP shifts. A is for day shift, P is for night shift. I want to sum all of the cells with the letter "A" in 1 cell and "P" in another cell, but it also is counting if there is an A or P in someone's initials making it look like we have enough people on a shift when there is not.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar here is a copy of the file
I don't see an attachment, nor a link.
