Simple statistics: counting compound things
While countif() can count the number of times a specific thing appears in a set of cells, countifs() counts the number of times a corresponding set of things appears in a corresponding set of locations. For example, countif() could count… Read moreSimple statistics: counting compound things