update Totals using current date
 

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

update Totals using current date
 

Perhaps:

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

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

"BrianMcC" wrote:

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