Question about Computers & Internet

1 Answer

Hi, looking for help to calculate columns using the sum. I'm looking to use the new total... Example... Old Balance + Additional Amount = New Total... and then the next time we add an additional amount to continue to Calculate a new total

Posted by on

  • notme10001 May 11, 2010

    Hi, What software are you using?

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 15 Answers

Download latest adobe and get open office free

Posted on Jul 30, 2009

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,
a 6ya expert can help you resolve that 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.
New users get to try the service completely Free afterwhich it costs $6 per call and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

When interest is compounded why does the accrued amount not become the principal aount for the next period of time


It becomes part of the new principal. The new principal is equal to the old principal + interest for the period.

As an example:
Principal $100
Interest Rate 10% compounded annually

Opening Closing
Balance Interest Balance
100 10 110
110 11 121
121 12.10 133.10

Good luck.

Paul

Mar 22, 2015 | Office Equipment & Supplies

1 Answer

How to calculate the percentage using the excel



Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?


Calculate the amount if you know the total and percentage For example, if you purchase a computer for $800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.



Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

1 Answer

How to get all balance sheet entries tally to excel


This is a very handy process when you're totaling or subtotaling columns. On the cell that you want the 'total' in type '=sum(column letter row number),(column letter row number). The first 'column letter row number' is where you want the first cell to be started in the total factor and the second 'column letter row number) is the last cell you want added in the total factor. The help (?) section is good at explaining formulas. Hope this helps, keep this process handy if you use Excel much because it'll be helpfull each time you subtotal or total columns.
Bob

Sep 23, 2009 | Computers & Internet

3 Answers

How do i insert a formula in a column to add each number & give a total at the bottom?


For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

2 Answers

Writing a formula for a sumif problem


Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

BTW, sent you a similar email about this.

May 07, 2009 | Microsoft Excel 2007 Home and Student...

1 Answer

CAN GET COLUMNS TO ADD UP AND GIVE TOTAL ONLY GET SUBTOTALS


Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum($A:$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.

Mar 14, 2009 | Microsoft Excel for PC

2 Answers

How to do profit and loss a/c in ms excel


Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)



Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)


I hope this helps

Mark

Jan 05, 2009 | Microsoft Computers & Internet

1 Answer

Related MS Excess 2003


Hi Esd,

I'm assuming you meant 'Excel' since 'SUM' is the command you're looking for.

If your totaling Column D for rows 5 through 35, this is what you would need in the cell your total would be:

=SUM(D5:D35)

Also, when in doubt, Click on the '=' (equal sign) in the formula bar for a list of functions and help using them.

Any problems? Click the Askme button near my name.

Thanks for using Fixya.
Mike

Dec 06, 2008 | Microsoft Computers & Internet

3 Answers

Excel Formula


columns total in additin cells of rows equal are total

Oct 24, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

Access 2003


Hi smiths, Try adding a Label to the report in Design View. In the Properties, select the control source for this field. Insert one for your vertical and horizontal calculations as needed. Hope this helps. Regards DeltaC

Sep 10, 2007 | Microsoft Office Standard for PC

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

Related Topics:

44 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...