Summing up of data for this month
 

Hi there

I have two columns of data, first one would be my contract number and
second one would be the date of completion of the contract. How do I go
about using summing up the number of contracts I've completed in a
particular month? For example:

Contract Number Date
------------------------ --------
27 1/11/2006
87 2/8/2006
76 1/1/2006
45 4/8/2006
78 9/12/2006
41 2/1/2006
08 9/6/2006
.. .

So from the above, I need the number of contracts I've done for the
month of January, February, so on and so forth. I'm kind of stuck with
dates for EXCEL.

Yup that's the general idea. Thanks!

Summing up of data for this month
 

=SUMPRODUCT(--(MONTH(g2:b5)=7),a2:a5)

--
Don Guillett
SalesAid Software

"BigMac" wrote in message
oups.com...
Hi there

I have two columns of data, first one would be my contract number and
second one would be the date of completion of the contract. How do I go
about using summing up the number of contracts I've completed in a
particular month? For example:

Contract Number Date
------------------------ --------
27 1/11/2006
87 2/8/2006
76 1/1/2006
45 4/8/2006
78 9/12/2006
41 2/1/2006
08 9/6/2006
. .

So from the above, I need the number of contracts I've done for the
month of January, February, so on and so forth. I'm kind of stuck with
dates for EXCEL.

Yup that's the general idea. Thanks!