View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BigMac BigMac is offline
external usenet poster
 
Posts: 6
Default 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!