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" ?

Dilly;340795 Wrote:
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)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95305