I would like to create a formula which can count number of cells in a column
matched with a predefined criteria AND another condition on another column:

Example: How many streets was I on when I spot parked minivans when I
cruised around Los Angeles?
Columns: Type of parked cars -- Names of streets