Summary of cost for Date Ranges by Month/year

Hi guys,

i have attached the spreadsheet

basically I am trying to total this spreadsheet up to work out a sum for the month by customer number.
some customers made a payment in jan 2012 and paid again in jan 2013, some paid twice in one month.

what needs to happen is

it needs to have customer number going down and the month/year going across the top with a summary paid for that month

i have attached the spreadsheet.

can anyone help?

You get better help, if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html

You did not attache an file.

Do you forgot the attachment?

Hi,

I can't see the workbook. Care to try again?

4 replies in same minutes!! This must be a record here!!!

Maybe..

=SUMPRODUCT(($A$2:$A$39=$J2)*(TEXT($G$2:$G$39,"mmmyy")=TEXT(K$1,"mmmyy")),$H$2:$H$39)

Try

In J2 and copy down for the customers list

=LOOKUP(REPT("Z";255);CHOOSE({1\2};"";INDEX($A$2:$A$100;MATCH(TRUE;INDEX(ISNA(MATCH($A$2:$A$100;$J$2:$J2;0));0);0))))

In K2 and copy down and across, this one.

=SUMPRODUCT((MONTH($G$2:$G$40)=MONTH(K$1))*(YEAR($G$2:$G$40)=YEAR(K$1))*($A$2:$A$40=$J2)*($H$2:$H$40))

Or with an pivot table.

See the attached file.