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

1701	$200.00	Feb-2013
1701	$30.00	Feb-2013

<tbody>
</tbody>

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!

1701	$200.00	Feb-2013
1701	$30.00	Feb-2013
1701	$200.00	Mar-2013
1701	$30.00	Mar-2013
1701	$30.00	Apr-2013
1701	$200.00	Apr-2013
1701	$200.00	May-2013
1701	$30.00	May-2013
1701	$30.00	Jun-2013
1701	$200.00	Jun-2013
1701	$200.00	Jul-2013
1701	$30.00	Jul-2013
1701	$30.00	Aug-2013
1701	$200.00	Aug-2013
1701	$30.00	Sep-2013
1701	$200.00	Sep-2013
1701	$200.00	Oct-2013
1701	$30.00	Oct-2013
1701	$200.00	Nov-2013
1701	$30.00	Nov-2013
1701	$200.00	Dec-2013
1701	$30.00	Dec-2013
1701	$30.00	Jan-2014
1701	$200.00	Jan-2014
1701	$200.00	Feb-2014
1701	$30.00	Feb-2014
1701	$200.00	Mar-2014
1701	$30.00	Mar-2014
1701	$30.00	Apr-2014
1701	$200.00	Apr-2014

<tbody>
</tbody>

 

[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!!!