Sum up values and add a new row

[xlpaul]

Hello - Let me start by saying that this website is a wonderful resource to excel related questions.

I am looking for solutions to a problem I have
Sheet 1 has values that I need summed up and the total added as a row on a differernt sheet.
So my sheet 1 would look like this

Date Amount
01/01 $10
01/01 $20
01/01 $30
01/02 $5
01/02 $15
01/02 $2
01/02 $1
01/04 $25 ( Note that there are no transactions for 01/03)

Sheet 2 should look like this

01/01 - $60
02/01 - $23
01/04 - $25

How do I accomplish this in Excel 2016. ?

-TIA

,

 

[DanteAmor]

Hi and welcome to the board!

You can use a pivot table

Book1
	A	B	C	D	E
1	Date	Amount
2	01/01/2020	$10		Date	Sum
3	01/01/2020	$20		01/01/2020	60
4	01/01/2020	$30		01/02/2020	23
5	01/02/2020	$5		01/04/2020	25
6	01/02/2020	$15		Total	108
7	01/02/2020	$2
8	01/02/2020	$1
9	01/04/2020	$25
Hoja10