Counting Dates

[Dilly]

Column A has a a list of letters (a,b or c) and Column B has a list of random
dates. How do i get a formula that will count all letters of "a" that have a
date in February for example.
I am trying to use a DSUM (if this is correct), however what would be the
criteria for a "date in febraury" ?

 

[Pecoflyer]

Column A has a a list of letters (a,b or c) and Column B has a list of
random
dates. How do i get a formula that will count all letters of "a" that
have a
date in February for example.
I am trying to use a DSUM (if this is correct), however what would be
the
criteria for a "date in febraury" ?

Hi,
I don't know about DSUM but the following should do
=sumproduct((a1:a100="a")*(month(b1:b100)=3))

( adapt the range to your needs but BOTH ranges must have same length)