Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

findadd sum last weekmonth

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Find/add sum, last week/month

Find/add sum, last week/month

ResolvedVersion 2010

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

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.

Excel tip:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.