LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Click a cell and update to current time / date ? Eric Excel Discussion (Misc queries) 3 October 4th 06 12:12 AM
How to auto update a cell with a current date Kell2604 Excel Discussion (Misc queries) 2 June 23rd 06 09:18 PM
Calculating monthly totals for current and previous year Pieman New Users to Excel 1 February 26th 06 12:43 PM
Can I automatically enter the current date or current time into a Ben New Users to Excel 7 October 19th 05 03:38 PM
Graphing past months (totals) and current month (weekly total) in Davin Charts and Charting in Excel 1 July 27th 05 05:01 PM


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"