98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Find/add sum, last week/month
Find/add sum, last week/month
Resolved · Medium Priority · Version 2010
Fri 1 Jun 2012, 10:25Delegate Marianne said...
Marianne has attended:
Excel Intermediate course
Excel Advanced course
Find/add sum, last week/month
I have an existing workbook to which I wish to add a new function/front sheet. On this I want a running tally of received amounts (per currency) in the last 7 days + in the last 30 days, by updating today's date.
The existing sheet is set up alphabetically, per customer. Dares of incoming payments are random in order, amounts will be in either GBP or USD.
What do I best use here, for my purpose, please?
Current set-up:
Customer Date rcvd USD GBP
A 25/05/12 12.00 48.00
B 02/04/12 1,000.00 582.00
C 01/06/12 580.00 20,000.00
Thanks a lot,
Marianne
Mon 11 Jun 2012, 11:40Trainer Anthony said...
RE: Find/add sum, last week/month
Hi Marianne, thanks for your query. It's a little difficult to advise you on which particular function you need to use for your situation, but it's definitely going to be one of the Date functions. There's a comprehensive walkthrough of them here:
http://www.cpearson.com/excel/datetime.htm
Hope this helps,
Anthony
Mon 18 Jun 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding Rows or Columns in an Excel 2010 WorksheetIf you want to add a row to an Excel spreadsheet, these are the simple steps you should take: |
