Countif and Countifs

Originally Posted by daddylonglegs

Try this version

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

That one did not work, it counted cells that did not meet the criteria.