Question about Computers & Internet

2 Answers

Budgets in excel

I want to create a budget in excel...and for my expenses section, i want to create "total expenses" cell...that updates each time i have a new expense. How can i do this, without having to update the formula? Currently, the formula has a range of cells in it to add but if I add new cells, I'd have to update the formula each time.

Posted by on

Ad

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 292 Answers

Hi Madih35
My solution is this:
Make sure there is a blank row just above the Total expenses cell.
Rewrite the formula to include the blank cell as well and save.
Every time you have a new expense which requires a new row, insert a row and type in the new cell, instead of typing in the existing blank cell. Your formula will be updated automatically.
Best of luck

Posted on Sep 01, 2009

Ad
  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 35 Answers

Dear Madiha35,

 

I would recommend the use of the Table Function in Excel.

 

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

 

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

 

Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

 

Step 1:  Enter your data into the worksheet.

 

Step 2:  Create Table

             Highlight the relevant data

             On the insert tab, click on Table

             

Step 3:  Verify Table range is correct, Click OK

 

Step 4:  Select the cell you where you wish to Sum Data.

         Click on Autosum.

 

Step 5:  To Insert new data

         Click on the sum row in the table, (Not the entire worksheet row)

         Right click, Insert, Insert Table rows from above

 

Step 6:  Enter new data in row

 

Step 7:  Data is automatically calculated in formula.

Posted on Oct 29, 2007

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

What things to keep in mind while setting budget for my wedding dress?


The budget of your bridal dress depends upon various factors. Whether you are going for a high-end designer or a medium-end one, check them out on their websites or visit to get an idea for the average budget. While setting the budget for your dress, do not forget to also consider the cost of alterations, shoes and other accessories. Many brides forget to add these costs and end up going above the limit. Also, do not try dresses that you know are way over your set budget. You do not want to end up madly in love with a dress that will disturb all your budget. There must be many beautiful options that fall within budget, stick with them to avoid unnecessary stress.

Jul 24, 2017 | setting Clothing

Tip

How to view total editing time updated in Real time in Word 2007



The total amount of time that a document has been edited is useful for lawyers, consultants, and other professionals who bill for their time.
Knowing how long you have spent working on a document enables you to provide a more accurate accounting of your time.
If you have a time budget that you’re trying to stick to, you may find yourself constantly checking the document’s Properties dialog box to view the Total editing time value.
Rather than wasting time performing that chore, add the EditTime field to your document.
Word’s EditTime field displays the total time, in minutes, that the document has had the system focus (and, presumably, has been edited) since the time at which the document was
created. This is the same as the Total editing time value displayed in the Statistics tab of the document’s Properties dialog box.
Follow these steps to add some code that displays the total editing time with the word minutes added for clarity:

1. Type some descriptive text (such as Total Editing Time).
2. Press Ctrl+F9 to start a new Word field (signified by the { and } braces).
3. Between the field braces, type the following:
EDITTIME # “0 minutes” * mergeformat
4. Press F9 to complete and update the field.

Now all you have to do is update the field (or simply press F9) to check the total editing time instead of going in the properties tab to see total time worked on the document.

on Jul 21, 2010 | Computers & Internet

1 Answer

I need to download a user manual for a Budget x401 cell phone


Phone manuals for your Budget Mobile California LifeLine ...

www.budgetmobile.com/california/phones/manuals.cfm
Budget Mobile offers a variety of phone models for our Government Assisted Lifeline Program. We offer several resources to view or download a User Manual for ...

Budget Mobile

www.budgetmobile.com/questions/
What is Budget Mobile LifeLine cell phone service? Budget ... If you experience equipment malfunction please read our Warranty & Return Policy for instructions.

Oct 16, 2015 | Cell Phones

1 Answer

How do you figure out the percentage of a budget


The percentage is simply 100 x (things you are interested in / total).
So for example the percentage of foodstuffs which go, with the other things to make up the household expenditure (budget) is
100 x (amount spent on food) / (total household spend), or
100 x (food budget) / (total household budget)

5.May.2014

May 05, 2014 | Office Equipment & Supplies

1 Answer

How to Move With budget?


It's not so difficult that. Don't worry trust on removal companies they will reduce the amount of your moving expense also they provide free moving material which definitely reduce your cost.

Budgeted Removal Companies in Your Area

Mar 20, 2013 | Computers & Internet

1 Answer

The Belvedere Arms takes £11,800 in drink sales and £5,600 in food sales in a week. In the same week the pub delivers £8,496 profit on drink and £3,640 profit on food. The week's sales...


Assuming the Belvedere Arms sells only food and drink:
a) Total sales for the week is the sum of the drink sales and food sales, £11,800 + £5,600 = £17,400
b) Sales budget is £16,200, so performance is (17,400-16,200)/16,200 = 1200/16200 = .074 which is up by 7.4%
c) Profit on food is £3,640 on total food sales of £5,600. 3640/5600 = .65 or 65%
d) Profit on drink is £8,496 on total drink sales of £11,800. 8496/11,800 = .72 or 72%
e) Total profit is £12,036 on total sales of £17,400. 12,136/17,400 = .697 or 70%

Aug 31, 2010 | Vivendi Excel@ Mathematics Study Skills...

1 Answer

What is the importance of agreeing to a budget and operating within it?


before building a pc you need to know your budget bec. parts have different prices, high ends are more expensive, if you buy expensive parts with limited budget, you would end up short in cash

Oct 19, 2009 | Anuman Interactive Home Budgets for...

1 Answer

IF Formula


You can use this formula
=IF(A2<=100,"Within budget","Over budget")
Which means
If the number above is less than or equal to 100, then the formula displays "Within budget". Otherwise, the function displays "Over budget" (Within budget)
or you and try something like this
=IF(A2=100,SUM(B5:B15),"")
which means
If the number above is 100, then the range B5:B15 is calculated. Otherwise, empty text ("") is returned ()
I got these examples from the help within Exel they give several more examples and more expaination.

Jan 10, 2009 | Microsoft Office Standard for PC

2 Answers

I am computer illiterate and i am wanting to do a household budget. i have the program office suite 2008 but don't know how to work it. any help would be greatly aprecated.


Hi
learn word 2007 from this site.so that u can easily understnd 2008
all the best




http://www.trainsignal.com/index.asp?PageAction=VIEWPROD&ProdID=107

Aug 12, 2008 | Computers & Internet

1 Answer

Microsoft excel(data analysing)


Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process. As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.

Sep 22, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

282 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18426 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...