| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM by month
i have the following case:
DATE Ammount 01.12.06 50 05.12.06 100 12.12.06 200 25.12.06 240 01.01.07 200 15.01.07 210 27.01.07 111 etc... I would like to SUM the ammounts by month month ammount dec. 06 590 jan. 07 521 how do I do that? thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM by month
=SUMPRODUCT(--(YEAR(A2:A8)=2006),--(MONTH(A2:A8)=12),B2:B8)
-- HTH Bob (change the xxxx to gmail if mailing direct) "Mortir" wrote in message oups.com... i have the following case: DATE Ammount 01.12.06 50 05.12.06 100 12.12.06 200 25.12.06 240 01.01.07 200 15.01.07 210 27.01.07 111 etc... I would like to SUM the ammounts by month month ammount dec. 06 590 jan. 07 521 how do I do that? thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding values based on current month | Excel Worksheet Functions | |||
| How to create a rolling 6 month average? | Excel Discussion (Misc queries) | |||
| holiday dates | Excel Worksheet Functions | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Linear Mode
