We assumed with a name like Francis that you're not greek. Did you want to
say "geek" instead?

Regards,
Fred.

"Francis" <xlsmate(AT)gmail(DOT)com wrote in message
...
try this
assume that col B always contain a date or blanks
adjust the column to yours

=SUMPRODUCT((A1:A6=1100)*(B1:B6<""))
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Caddie66" wrote:

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?