try this, changing columns to suit
=SUMPRODUCT((F2:F12=1100)*(LEN(TRIM(G2:G12))0))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Caddie66" wrote in message
...
How do you count the number of times specific criteria is met in Column A,
and different criteria is met in Column B.
For example, Column A has numbers 1100, 2200, 3300 all formated as
numbers.
Column B is formatted as and has dates, but some cells in Column B will be
blank.
How would you count the number of times 1100 appears in Column A when
there
is date in Column B?