update Totals using current date

G

Guest

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
 
G

Guest

Perhaps:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

An odd problem with SUM(A:B) and AutoSum 2
When date changes I lose my data 3
Remove date format? 3
Count cells every 12th column 6
How to auto update a cell with a current date 2
Highlight a row with the current date. 11
Transferring date from multiple worksheets to a "totals" worksheet. 0
copy data from master sheet new 2

Top