It seemed to work with counting the instances for 1100, but it did not return
the correct a result for 2200 and did not return any result for 3300. The
answers should have been
1100 = 2
2200 = 2
3300 = 3

instead I get
1100 = 2
2200 = 1
3300 = 0


"Don Guillett" wrote:

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?