For the spreadsheet below, column A is the initials of a salesperson and
column B is the type of deal (f is a finance, c is a cash and L is a lease
deal. I want to count the number of L's there are for GR and CC.

I have tried many combinations of IF statements and cant figure out how to
combine the two. How many times does L appear in column B when CC is in
column A? Once I get it for one, I can make the necessary changes to count
the rest.

My spreadsheet looks like this
column
A B
GR L
GR L
CC C
CC L
CC L
CC L
GR F
GR C
CC C
GR L
CC L
CC C
CC L
GR F
CC L