Countif and Countifs

Originally Posted by alexfamily5

I think in "countif" it will count a cell if the letter is anywhere in the cell, and that one has both N and C, so it is counting that cell.

No, the formula I suggested doesn't count "NICU" - it will only count cells that contain exactly "C", "D", "N" or "P" (upper or lower case) - I get 3 as the PM result for Mon - that counts the "D" in G4 and the "C"s in M4 and S4