Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

to keep a running balance

What I want to do is take the balance from a previous worksheet, in the same
work book and subtract from that balance. Help!!!


Post your answer or comment

comments powered by Disqus
I have a spreadsheet designed to calculate the amount of vacation time and overtime I have earned and used throughout the year. The sheet is designed to keep a running tally and is constantly updated. I can not figure out how to project the current balance to a box outside the main chart. Since the balance changes weekly either by use of vacation/sick time or by earning more vacation/sick time, it is difficult for me to write a formula to keep that one box constantly up to date without constant maintenance. Any tips would be much appreciated.

formula to keep a running tally of the number of times a certain word appears
in a spreadsheet...

I'd like one cell that I can refer to that will always show me the number of
times SDP is listed in a spreadsheet.

Thanks in advance

I apologize in advance if I am posting this questing in the wrong group or this question has been asked before.

I am an Excell novice and would like to learn more. I've attached a sample worksheet to illustrate what I am trying to achieve.

Basically I would like to keep track of inventory usage of lets say everyday office supplies for a daily basis that are then totaled for the week. I then want to take that totaled number and start adding it for the begining of a new week. I want to automate this process by maybe including it in a MACRO.

In the attached Book1.xls there is a "Reset" macro button that when pressed erases all the daily values. In week 1 those are C7 to G10. In week 2 you can see that I manually inputed the ending week 1 totals under PREV WK collumn.

How can I automate the adding of the ending week totals to a new week's previous weeks and keep a running total?

My vision is to have all this done with just one week showing on the excell sheet. All I have to do is change the dates. Thanks in advance

EDIT: I figured it out thanks.

Hello, I have created a daily budget tracking sheet and need some help to automate it fully. I have a column called "Category" that lists out the various categories to budget for (Mortgage, electricity, gas, etc). I have another column called "Budget" where I have listed out how much I want to budget for each category. Then I have a column called "Expense" where I list out how much I spent in a given category. Finally, there is a column called "Amount Left (Category)" where I want to be displayed how much is left for that category.

I cannot seem to figure out how to keep a running balance in the "Amount Left (Category)" column. When I make a purchase in a category I would like for this column to automatically stay updated with the amount left in that category.

Does anyone know how I could accomplish this? Any help would be greatly appreciated!

Hi!

I am trying to set up a worksheet where I have different columns for each
area in a budget (ie "Food", "entertainment", "security", etc)

Column A&B = Date and decription of each item
Row 1: Budget areas listed above

Now I have done the "freeze frame" command so that no matter where I scroll,
I ca always see Row #1. I would like to have a running balance for each
column that I could also see no matter where in the worksheet I am.

For Example, C1 = "Food"
C2 = a running balance for how much is left in the food budget
C3 - C(really big number) would be where I enter money spent on food, or
donations to the food budget, and C2 would automatically update to tell me
the current balance

I hope I explained this okay. I'm not married to the idea of setting it up
exactly like this, if there is a better way. I just want to be able to have a
running balance for each budget area that I can easily see without having to
scroll all over the place.

Thanks in advance!

The built in Excel help gave me some new ideas (search for "Calculate a
running balance" in excel help), but I still want to see if someone out there
knows how to do what I'm trying to do.

I've set up a budget on excel, where all I have to do is enter in how much
my paycheck was for that week, and it will divide it up among preset impound
accounts according to my calculations. I would then take the divided up
amounts and manually enter them into my quickbooks program, which, after only
a month or two, is driving me crazy. I HATE double entry.
I'm trying to establish a running balance directly on my excel spreadsheet,
preferably on only one line, that will save my current totals, and allow me
to re-use that same spreadsheet to enter in my Next paycheck, and so on. I
also would like a million dollars tax free, but that ain't happening either,
I know.
Pretty much, all I'm trying to do is avoid double entry. If I can set up a
formula, or input field of some sort, I wouldn't care if I have to have more
than one line. I just don't want to have to recreate the formula on a whole
new workbook/worksheet, because it takes just as long as what I was doing.
Last question, is it possible there's already a program out there that will
do this?

Hoping there's a genius or two out there,
-Jim

I'd like to keep a running 'Top Five' in Excel. Attach names to values, and
list the top five names that the values are attached to.
Eg:
Mike - 5
Steve - 6
At the moment, the top value would be 6, so the cell would display 'Steve'.
But if we add 2 points to Mike, the cell would automatically update to
display 'Mike' as he has a higher value. Is this possible?

The built in Excel help gave me some new ideas (search for "Calculate a
running balance" in excel help), but I still want to see if someone out there
knows how to do what I'm trying to do.

I've set up a budget on excel, where all I have to do is enter in how much
my paycheck was for that week, and it will divide it up among preset impound
accounts according to my calculations. I would then take the divided up
amounts and manually enter them into my quickbooks program, which, after only
a month or two, is driving me crazy. I HATE double entry.
I'm trying to establish a running balance directly on my excel spreadsheet,
preferably on only one line, that will save my current totals, and allow me
to re-use that same spreadsheet to enter in my Next paycheck, and so on. I
also would like a million dollars tax free, but that ain't happening either,
I know.
Pretty much, all I'm trying to do is avoid double entry. If I can set up a
formula, or input field of some sort, I wouldn't care if I have to have more
than one line. I just don't want to have to recreate the formula on a whole
new workbook/worksheet, because it takes just as long as what I was doing.
Last question, is it possible there's already a program out there that will
do this?

Hoping there's a genius or two out there,
-Jim

I would like to be able to keep a running total in one column and automatically have it updated every time I add more info is this possible? Heres a link to a example I'm trying to do. Look at the YTD column Thanks
http://i273.photobucket.com/albums/j...kSimulator.jpg

Hi!

I am trying to set up a worksheet where I have different columns for each
area in a budget (ie "Food", "entertainment", "security", etc)

Column A&B = Date and decription of each item
Row 1: Budget areas listed above

Now I have done the "freeze frame" command so that no matter where I scroll,
I ca always see Row #1. I would like to have a running balance for each
column that I could also see no matter where in the worksheet I am.

For Example, C1 = "Food"
C2 = a running balance for how much is left in the food budget
C3 - C(really big number) would be where I enter money spent on food, or
donations to the food budget, and C2 would automatically update to tell me
the current balance

I hope I explained this okay. I'm not married to the idea of setting it up
exactly like this, if there is a better way. I just want to be able to have a
running balance for each budget area that I can easily see without having to
scroll all over the place.

Thanks in advance!

I have had some help from Mr Ross and a couple others regarding the ability to keep a running total in a cell by adding a number to that cell displaying the resulting sum. Everyone who replied was great....Thanks alot.
I finaly found this macro that runs automatically every time and works great......But only for one cell so far..."D3"...Ugh!!! I need this macro to work for the following range of cells "colums d thru j from row 3 down to 28 in each colum. Each cell is an individual.

 
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Static dAccumulator As Double
With Target
If .Address(False, False) = "D3" Then
If Not IsEmpty(.Value) And IsNumeric(.Value) Then
dAccumulator = dAccumulator + .Value
Else
dAccumulator = 0
End If
Application.EnableEvents = False
.Value = dAccumulator
Application.EnableEvents = True
End If
End With
End Sub
As you see the macro includes cell D3 only, I have made several attempts to include more cells but have failed.... I tried like this

...and so on" Then

I have tried ....If .Address(False, False) = "D3:J3" Then
and I have tried ....If .Address(False, False) = "23Rx7C" Then
I can make it work for cell d3 but not the others. Will I have to repeat this code for every cell? Anyway, I will keep hacking at it. If anyone has any info on this problem I would greatly appreciate it.

jlg371
View Public Profile
Send a private message to jlg371
Find all posts by jlg371
Add jlg371 to Your Contacts

I am trying to keep a running average of daily calories used in a specific
period. For Instance taking the avg. of 5 days and be able to to automaticly
upate the running average on day6,7,8,9, etc

I have a form that I am able to clear with a macro reset button. How can I
keep a record of the values within the form and add them to the previous
values that were in that same form before I press the reset button? I want
to keep a running total log is what I guess I'm trying to say.

I would like to use Excel for a television program director's rundown
sheet. Is there a simple formula that would show running time by
segment from the start of the program to the end? In other words, the
program would start at 00:00:00 and end at 30:00:00. I would like one
column to keep a running time total for each element of the program.
Thanks for your help!

Good Morning Everyone,

I am trying to use excel to keep a running total using an IF/THEN statement (or any command that will suit this purpose). I'm familiar with the concept through programming in BASIC. I need a formula that would accomplish the following:

IF A2 = "E1" THEN X = X + 1
IF A2 = "E2" THEN Y = Y + 1
IF A2 = "E3" THEN Z = Z + 1

Then the process would repeat for cell A3, A4, etc. The database would need to be able to have 20 separate variables that start at 0, and then have 1 added to them if the A column matches a certain criteria. The running total is to be used for creating a chart that coud say that in all of the data, (X)% have E1 listed in the field, (X)% have E2 listed in the field, (X)% have E3 listed in the field, etc.

Please note that in the above example, "E1", "E2", and "E3", do not refer to those cells withing the spreadsheet, but a string of text data (representing locations).

I can't get this to work without having to reset the calculation each time. I need this spreadsheet to be able to update automatically as rows are added in. When new rows are added, I need the running total to update, keeping all of the previous data. New rows would be added frequently.

The spreadsheet is to show what percentage of items were given to each type of location.

Thank you for your help and advice, and have a great day!

-Steve

I run a query in Access 2007 that exports data into my spreadsheet. I am trying to figure out how to keep a running balance. I am attaching a example with highlighted cells as an example. There are various orders against the on hand inventory that I need to subtract from the balance and then be able to sort my sheet by negative balances and dates.
Thanks!

Hello there,

I need help creating a formula for a cell in which a running balance of withdraws is calculated.

I want to be able to simply create a running balance. I have one cell in which I put the dollar amount for all of my withdraws (I will simply input a new amount over the previous one so I'm only using one cell for the withdraws) and then the other cell I want to create a running balance which will continuously add the withdraws.

Here's how I want it to run. I make a withdraw of $10.00 which I input under the "withdraw" header cell. Now I have a running total of $10.00 in under my "total withdraws" cell. A few days later I have a withdraw of $5.00. So I mouse over the cell that I typed $10.00 (under the "withdraw cell") and type in $5.00. Now the "total withdraws" cell has a running balance of $15.00

I want to know what the formula would be for the "total withdraws" cell? I've played around with different formulas and operators and I can't get it to work.

Thank you for your time!

Mike

I'd like to keep a running 'Top Five' in Excel. Attach names to values, and
list the top five names that the values are attached to.
Eg:
Mike - 5
Steve - 6
At the moment, the top value would be 6, so the cell would display 'Steve'.
But if we add 2 points to Mike, the cell would automatically update to
display 'Mike' as he has a higher value. Is this possible?

I have a formula, ex. =E2+C2-D2 to calculate a running balance. I don't want
to enter it each time I add or subtract an amount. I can't figure out where
to put it in the balance column so my total is on the correct line. I also
can't figure out how to get it to carry down the balance column for as far as
I need it. I hope this makes sense. Thanks!

I'm trying to make a spreadsheet to keep track of the miles I bike and the
total time. For each of these, I made a running balance. The entire range
displays the total. I would like to hide the displayed future totals untill
a new value is entered for that particular day.

example: miles total
1 1
2 3
3
3
3

I don't want to see all those 3's until I input new data

example: miles total
1 1
2 3
3 6

Thanks for any help

Hi

I can download statements from my bank (HSBC, for future Googlers) in the following format. Does anyone know what formula I can use to show a running balance in column D (i.e. to the right of 'amount')?
I've tried various things and the only way I've had success is to filter the credits and debits into seperate columns due to the way the formula interprets the '-' symbols...

Thank you!
date description amount 01.12.2011 supermarket -10 02.12.2012 wages 1000 04.12.2011 butcher -5 06.12.2011 child benefit 80

How do you write a formula to figure out the following:

Within one workbook I am comparing a running total Jan-Dec (sheet A) to (Sheet B) which has the following items:
Principal (i.e.$1000.00)
Interest Rate (i.e. 10%)
Total No. of Payments (i.e.12 payments)
Monthly Payment amount (i.e.$50.00)
Example Payment:
$1000.00*10%=$1100.00
Payment made on Jan=$50.00
Balance = $1050.00
Next payment in Feb = $50.00
Balance (which already includes the interest rate)=$1000.00

I want to be able to make a monthly payment on sheet A and have it refect accuratelyon Sheet B. Keeping a running balance which includes the interest accured on the outstanding balance.

Thanks,

Papokie

I'm creating a budget balance worksheet, and am wanting to know what formula
to use if I want the balance amount to deduct continuously each time
information is entered, without having to create a new row each time

I have had some help from Mr Ross and a couple others regarding the ability to keep a running total in a cell by adding a number to that cell displaying the resulting sum. Everyone who replied was great....Thanks alot.
I finaly found this macro that runs automatically every time and works great......But only for one cell so far..."D3"...Ugh!!! I need this macro to work for the following range of cells "colums d thru j from row 3 down to 28 in each colum. Each cell is an individual.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
      Static dAccumulator As Double
      With Target
         If .Address(False, False) = "D3" Then
            If Not IsEmpty(.Value) And IsNumeric(.Value) Then
               dAccumulator = dAccumulator + .Value
            Else
               dAccumulator = 0
            End If
            Application.EnableEvents = False
            .Value = dAccumulator
            Application.EnableEvents = True
         End If
      End With
   End Sub
As you see the macro includes cell D3 only, I have made several attempts to include more cells but have failed.... I tried like this
I have tried ....If .Address(False, False) = "D3:J3" Then
and I have tried ....If .Address(False, False) = "23Rx7C" Then
I can make it work for cell d3 but not the others. Will I have to repeat this code for every cell? Anyway, I will keep hacking at it. If anyone has any info on this problem I would greatly appreciate it.


No luck finding an answer? You could always try Google.