Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

(NT) Excel Running Total I Think ?

Jul 24, 2005 7:55AM PDT

In excel 2002 trying to get a formula that will keep a running total. Say you go to a store and deliver 10 cases , close save that worksheet ,then go to another store deliver 20 cases etc. etc. at the end of the route i need to have a total of how many cases were deliver ??
I beleive they call this a running total
Anybody know the formula to do this ??
Thank You
Mac

Discussion is locked

- Collapse -
My cheap trick.
Jul 24, 2005 9:17AM PDT

I place what's to be totaled in say... Column C starting at say Row 10. Then at D10 I could SUM(C10..C255) or similar.

Just make the entries on column C and I have my total in the same spot.

Bob

- Collapse -
Me too
Jul 24, 2005 10:42AM PDT

The formula in D10 would be =SUM(C10:C255).

There's a quick way to do it as well.

In the tool bar along the top there is a button that looks like a Greek E, (Epsilon?).

Click cell D10, press the E button then highlight cells C10 thru to C255, release the mouse button, press Enter. The formula above is entered for you.


Mark

- Collapse -
Greek S
Jul 24, 2005 5:10PM PDT
- Collapse -
(NT) (NT) And, of course, congrats with your red M.
Jul 24, 2005 8:19PM PDT
- Collapse -
Many thanks Kees
Jul 25, 2005 8:58AM PDT

and for the Sigma. I didn't know which one it was.

Mark

- Collapse -
Sounds like ...
Jul 24, 2005 10:45PM PDT

some work to total variable cells (the cells entered today) in different workbooks.

It's easier if you use different worksheets in the same workbook (one per store). Use dsum function for the selection (same goes for different workbooks, by the way).

Alternatives include:
- Put everything in one sheet, and use things like filters or pivot tables for reporting.
- Use a real database (like Foxpro or Access, if you want to stay with Microsoft) for more flexibility.

Kees