Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter variable data into a formula | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |