You either have to list them manually (not real difficult if they're
consecutive dates) or you need to use a helper column to extract the date
portion then extract the uniques.

I'm guessing you have data for every day of a time span.

Just enter the first date in D2 then drag down the column and the
consecutive dates will fill-in.

--
Biff
Microsoft Excel MVP


"RedDixieCup" wrote in message
...
I can't get the unique day to come up?

"T. Valko" wrote:

Try this...

Dates/times in the range A2:A20
Values to sum in the range B2:B20

D2:Dn = unique dates

D2 = 1/1/2009
D3 = 1/2/2009
D4 = 1/3/2009
etc
etc

Enter this formula in E2 and copy down as needed:

=SUMPRODUCT(--(INT(A$2:A$20)=D2),B$2:B$20)

--
Biff
Microsoft Excel MVP


"RedDixieCup" wrote in message
...
I have two colums of data, the first is a time date stamp (mm/dd/yyy
hh:mm)
and the second is a rainfall total for each entry (0.00). I need to get
a
daily rainfall total.