| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summary by Months
I am trying to make a summary of deliveries on a monthly basis
A B 1 1/11/09 20.19 2 2/11/09 19.81 3 1/12/09 25.00 i want to get the result where Nov 09 will be 40.0 and Dec 09 will be 25.0 but cant seem to make it work. Can anyone please help me with a Formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summary by Months
Hi,
Try this =SUMPRODUCT(($C$4:$C$6=C10)*($C$4:$C$6<C11)*($D$4 :$D$6)) where C10 holds 1/11/2009 and C11 holds 1/12/2009. D4:D6 holds the amounts -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Furby73" wrote in message ... I am trying to make a summary of deliveries on a monthly basis A B 1 1/11/09 20.19 2 2/11/09 19.81 3 1/12/09 25.00 i want to get the result where Nov 09 will be 40.0 and Dec 09 will be 25.0 but cant seem to make it work. Can anyone please help me with a Formula? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summary by Months
=SUMPRODUCT((TEXT(A1:A10,"mmyyyy")="112009")*B1:B1 0)
OR 'with a date reference in cell C1 =SUMPRODUCT((TEXT(A1:A10,"mmyyyy")=TEXT(C1,"mmyyyy "))*B1:B10) -- Jacob "Furby73" wrote: I am trying to make a summary of deliveries on a monthly basis A B 1 1/11/09 20.19 2 2/11/09 19.81 3 1/12/09 25.00 i want to get the result where Nov 09 will be 40.0 and Dec 09 will be 25.0 but cant seem to make it work. Can anyone please help me with a Formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 months prior and 3 months post a date | Excel Worksheet Functions | |||
| Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Linear Mode
