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?

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?

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?