I have 2 worksheets - I am looking to do a lookup by date and populate a
subtotal.

the 1st has transaction level details by day.
i.e.
12/1 $1
12/1 $2
12/1 $3
12/2 $4
12/3 $5
12/3 $6

the 2nd has totals by day.
12/1 $6
12/2 $4
12/3 $11

I am looking to place a formula in the 2nd sheet to eliminate having to key
the daily total in.

Any suggestions what formula to use? Thanks!