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 ...
HansVogelaar here is a copy of the file
I don't see an attachment, nor a link.
Krowley04 Assuming the target "A" and "P" values are always the first letter in each cell, and as long as the other codes you're using never start with "A" or "P", then the COUNTIF function would be sufficient. For example:
=COUNTIF(B3:B24,"A*") =COUNTIF(B3:B24,"P*")- This seems good if one takes away the wildcard/star to exclude persons initial like AJF and only count A's.
