ive working on a new spreadsheet for tracking Sngs and MTTs and i cant figure out something that seems like it should be fairly standard.

I have a column with the type of game (i.e. Sng, MTT, Cash) and a column for ITM (yes/no).

im trying to separate ITM for Sng's and ITM for MTTs.

example:

Game ITM
MTT yes
Sng yes
Sng no
MTT no
Sng yes
etc, etc.

what formula do i use to find the number of Sngs ITM or MTTs ITM?

i thought it was a "COUNTIF" function, but cant get it to work. any help would be much appreciated.