sum daily totals

[fermerboy]

Hi all
I have a sheet with the data collected from a weather station on it. The rainfall is collected/recorded every 10mins, and some days every 30mins.
What I want to do is total all the rainfalls for that day and put the total in another column.
So column A Date and Time
Column B Rainfall recorded
Column C daily total

Is there a function to do this?
Ideally one function dragged down the column would be the answer.
I'm not too hot on Date type functions.
Thank you
Fermerboy

[SteveG]

If you put the dates you want to total for in C and your formula in D then try,

=SUMIF($A$2:$A$12,C2,$B$2:$B$12)

Change your ranges as needed.

HTH

Steve