| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To goup in each month on date column
I am using office 2007 and I have an excel sheet with the following
Date OS 2/1/2009 200.30 2/1/2009 300.00 3/2/2009 400.00 5/2/2009 600.00 How I can group the excel to know outstanding in each month. To group January os and February os and so on.... Please help with thanks and Regards |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To goup in each month on date column
Try
=SUMPRODUCT((TEXT(A2:A10,"mmyyyy")="022009")*(B2:B 10)) with the date in cell C1 =SUMPRODUCT((TEXT(A2:A10,"mmyyyy")=TEXT(C1,"mmyyyy ")*(B2:B10)) -- Jacob "pol" wrote: I am using office 2007 and I have an excel sheet with the following Date OS 2/1/2009 200.30 2/1/2009 300.00 3/2/2009 400.00 5/2/2009 600.00 How I can group the excel to know outstanding in each month. To group January os and February os and so on.... Please help with thanks and Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing values in a column if the date in another is of a certain month | New Users to Excel | |||
| If date in column A is less than 15th of month can I display next. | Excel Discussion (Misc queries) | |||
| automatic month/date in a column | Excel Worksheet Functions | |||
| how do I join month(#) in col a and day(#) in column b to a date? | Excel Discussion (Misc queries) | |||
| Formula for Extracting Month out of a Date column | Excel Discussion (Misc queries) | |||
Linear Mode
