excel formula needed

  gengiscant 15:12 08 Oct 09
Locked

My better half needs to keep a record of how many paces she walks in a day. I have started a spread sheet with the days of the week but would like to have a weekly total, adding of the 7 days of the week together either as a running total adding Tuesday to Monday then Wednesday to that and so on,or just a total of the whole week when adding the lastday.

Please keep it simple as this at the ripe old age of ?? is my first foray into excel.

Thanks.

  Fruit Bat /\0/\ 15:42 08 Oct 09

Not used excel for a while (don't have it on my current machine) but if I remember correctly there is a symbol that looks like a backwards E, this will auto sum a column.

so if you have days of week in column A1-7 and paces in column B1-7 the click on B* then click on the Autosum symbol.

  Fruit Bat /\0/\ 15:43 08 Oct 09

B*=B8

  wiz-king 15:51 08 Oct 09

Use the sum button; put your cursor where you want the totals, click to highlight the cell then click on the sum button (the one that looks like a back-to-front E)and adjust the range if you need to. That will give you a weekly running total.

  gengiscant 16:27 08 Oct 09

Sorry folks but your replys are not simple enough.
My days of the week go accross the sheet B-H so the sum formula need to happen in cell I1 then it will be I2 and so on.

  wiz-king 16:39 08 Oct 09

Put a number into B1, put the cursor on I1 click to highlight the cell,click on the sum button and it should do the trick.

  BRYNIT 16:45 08 Oct 09

All the Help and How to files on excel from 2000 to 2007 easy to understand.

  BRYNIT 16:46 08 Oct 09

Forgot to put the link. click here

  gengiscant 18:08 08 Oct 09

Cheers folks,change the sheet around so that the days of the week went down instead of across the sheet and followed WIZ-KING's suggestion,perfect.

Thanks again all.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Best iMovie for Mac tips 2017 | How to edit video with iMovie: 26 brilliant video editing tricks…