Sorry, I don't clearly understand what you want to do, but if you can explain a little more, I can help. If you want to subtract one cell from a column total, sum the column and subtract the one cell. If there is a need to subtract adjacent column entries, or similar type needs, there are formulas that can do this easily as well. Just a little more info - we'll have a FixYa!

Posted on Apr 27, 2008

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.

the service is completely free 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

put in result row

=A1-A2

or = A1-A2-A3

A being the column

the numbers 1 2 3 are the rows

or go to result cell type =

then click on cell then press -

then click on cell to minus then press -

the click on next cell to minus

=A1-A2

or = A1-A2-A3

A being the column

the numbers 1 2 3 are the rows

or go to result cell type =

then click on cell then press -

then click on cell to minus then press -

the click on next cell to minus

Dec 08, 2016 | Computers & Internet

- Select a cell
- in the Fx section type =SUM(
- Click another cell
- The cell should highlight and the Fx should display (for instance =SUM(C3
- modify the Fx to read =SUM(C3-
- Click another cell
- Fx should read (for instance) =SUM(C3-D3
- Modify the Fx to read =SUM(C3-D3) by adding a closing bracket
- Put a number in C3
- Put a number in D3
- B3 will display the result of the subtraction

Mar 08, 2015 | Microsoft Excel 2010

You have to start the sequence with a slightly different formula because there is no preceding value for Monday.

The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.

Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.

Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

Mar 06, 2015 | Microsoft Excel 2010

Best bet would be to utilize the "Help" function for formulas. You will need to set up a formula for each column you would like to format. Or simply add a Function (123-456) or (123+123) That way the cell will know the math. Good Luck

Feb 10, 2015 | Microsoft Office 2010 Home And Student...

1. Make sure you have entered the numbers you'll need in necessary columns

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

Aug 03, 2010 | Microsoft Excel for PC

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

- =A1-A2
- =SUM(A1,-A2)

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Computers & Internet

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Computers & Internet

Put the figure which you have to multiply in cell A1, Put the figure in cell A2 by which you have to multiply by, type =A1*A2 in cell A3. You will get the right answer.

You may substract, multiply or add by this method by appropriate mark in cell A3 in between A1 and A2.

npbhoge@rediff.com

You may substract, multiply or add by this method by appropriate mark in cell A3 in between A1 and A2.

npbhoge@rediff.com

Jul 29, 2008 | Microsoft Excel for PC

use a line chart instead with up/down bars

Nov 01, 2006 | Harvard ChartXL 3.0 (163103)

81 people viewed this question

Usually answered in minutes!

×