How to Combine Total $ Amount if 2 Values are the same and put into new table

[georgr]

I have a Table that shows Account Numbers and Date of Payment
Most accounts have 2 Payments in the same month.
I need a formula that adds the total amount per Account number per month and puts it all into a new Table!

For example those 2 rows

[TABLE="width: 381"]
<tbody>[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Feb-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Feb-2013[/TD]
[/TR]
</tbody>[/TABLE]

should be combined into this

1701 $230 Feb-2013

and so on for the remaining months and Account#, I have about 200 different accounts with 2 payments ea month for a period of 4 years.

Thank YOU!

[TABLE="width: 381"]
<tbody>[TR]
[TD="align: right"]

[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Feb-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Feb-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Mar-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Mar-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Apr-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Apr-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]May-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]May-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Jun-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Jun-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Jul-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Jul-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Aug-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Aug-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Sep-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Sep-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Oct-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Oct-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Nov-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Nov-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Dec-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Dec-2013[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Jan-2014[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Jan-2014[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Feb-2014[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Feb-2014[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Mar-2014[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Mar-2014[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$30.00[/TD]
[TD="align: right"]Apr-2014[/TD]
[/TR]
[TR]
[TD="align: right"]1701[/TD]
[TD="align: right"]$200.00[/TD]
[TD="align: right"]Apr-2014[/TD]
[/TR]
</tbody>[/TABLE]

 

[AlKey]

Maybe something like this
formula for unique dates: Enter D2 and copy down

[B]=INDEX(C$2:C$31,MATCH(0,INDEX(COUNTIF(D$1:D1,C$2:C$31),,),))[/B]

then
in E2 and copy dwon

[B]=A2&" "&TEXT(SUMIF(C:C,D2,B:B),"$0")&" "&TEXT(D2,"mmm-yy")[/B]

Excel 2016 (Windows) 32 bit
	A	B	C	D	E
1				Date	Concatenated values
2	1701	$200.00	Feb-13	Feb-13	1701 $230 Feb-13
3	1701	$30.00	Feb-13	Mar-13	1701 $230 Mar-13
4	1701	$200.00	Mar-13	Apr-13	1701 $230 Apr-13
5	1701	$30.00	Mar-13	May-13	1701 $230 May-13
6	1701	$30.00	Apr-13	Jun-13	1701 $230 Jun-13
7	1701	$200.00	Apr-13	Jul-13	1701 $230 Jul-13
8	1701	$200.00	May-13	Aug-13	1701 $230 Aug-13
9	1701	$30.00	May-13	Sep-13	1701 $230 Sep-13
10	1701	$30.00	Jun-13	Oct-13	1701 $230 Oct-13
11	1701	$200.00	Jun-13	Nov-13	1701 $230 Nov-13
12	1701	$200.00	Jul-13	Dec-13	1701 $230 Dec-13
13	1701	$30.00	Jul-13	Jan-14	1701 $230 Jan-14
14	1701	$30.00	Aug-13	Feb-14	1701 $230 Feb-14
15	1701	$200.00	Aug-13	Mar-14	1701 $230 Mar-14
16	1701	$30.00	Sep-13	Apr-14	1701 $230 Apr-14
17	1701	$200.00	Sep-13
18	1701	$200.00	Oct-13
19	1701	$30.00	Oct-13
20	1701	$200.00	Nov-13
21	1701	$30.00	Nov-13
22	1701	$200.00	Dec-13
23	1701	$30.00	Dec-13
24	1701	$30.00	Jan-14
25	1701	$200.00	Jan-14
26	1701	$200.00	Feb-14
27	1701	$30.00	Feb-14
28	1701	$200.00	Mar-14
29	1701	$30.00	Mar-14
30	1701	$30.00	Apr-14
31	1701	$200.00	Apr-14
Sheet3

 

[georgr]

AlKey,

thank you so much for your suggestion, it works with just the data supplied here (31 rows), but it doesn't work with my multiple accounts and 3 years of data.
I've been struggling for a few days to have it do what I really need to...
Let me try and explain what I am ultimately trying to accomplish..

I uploaded my excel file here:
http://renges.com/2013-2016.xlsx


The First Sheet has the transaction amounts and dates I need.
I am basically trying to add up the amounts by unit PER MONTH!

and than fill that total payment per unit per month into my 2013-2016 SHEET.

Any chance you could help me accomplish that?

THANK YOU!!!