ExcelBanter - To goup in each month on date column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - To goup in each month on date column (https://www.excelbanter.com/excel-discussion-misc-queries/249840-goup-each-month-date-column.html)

pol

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

Jacob Skaria

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

All times are GMT +1. The time now is 11:50 PM.