Countif and Countifs

Originally Posted by alexfamily5

... If I wanted to do the exact same thing but count up the sum of all "C", "P", and "NICU" cells, what would the formulas be?

Try this version

=SUM(COUNTIFS($C$2:$Z$2,AA$2,$C3:$Z3,{"C","P","NICU"}))