on second sheet: list each day in column A; in column B:

=SUMIF(Sheet1!E1:E5,A1,Sheet1!F1:F5) where e1:e5 and f1:f5 represent your
daily data on sheet1. copy down beside each day on sheet 2.

--
hope to help,
cm


"nitengale" wrote:

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!