Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel

Status
Not open for further replies.
demon147

demon147

Technical User
Jun 29, 2001
30
CA
Is there a formula in excel that would allow me to have a running sum in a single cell.

For Example:

In the cell the total was 10 and I typed 20 in the same cell and the total would automatically update to 30.

Help Appreciated
 
Sort by date Sort by votes
Wouldn't it work to sum the target cell AND the main cell? That way, when the target cell is blank, you're adding "0 + 10" then it goes on to "10 + 20" or whatever. Something like
Code: 
=Sum(A1, A2)
where A2 is the cell that holds the total. ----------------------------------------
If you are reading this, then you have read too far... :p

lightwarrior@hotmail.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
306
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
304
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
901
shytott
shytott
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
700
SoftwareRT
SoftwareRT
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
316
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top