update Totals using current date

B

BrianMcC

Continuous daily Spreadsheet which has multiple rows of data entered during
day. Have 2 complicated Totals Fields A10 and A15 which need to only look at
data entered today (date and time is entered for each row). Has someone a
formula to cope with this as say when the database is opened in the morning
A10 and A15 will update themselves for the ongoing day.
Many thanks in advance
 
T

Toppers

Perhaps:

=SUMPRODUCT((A1:A10=TODAY())*(B1:B10))

Where Column A are dates
Column B data to the summed
HTH
 
Top