Try SUMPRODUCT. See Bob Phillip's nice coverage at his:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Troi-Xanh" wrote in message
...
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