FORMULA; ADD A COLUMN, SUBTRACT 1 CELL, TAKE THE TOTAL X 10%
 

I want to total a column, subtract 1 particular cell from the total, and
take the total times 10%. I know it should be easy but......

FORMULA; ADD A COLUMN, SUBTRACT 1 CELL, TAKE THE TOTAL X 10%
 

What do you mean by total times?

"Teresea" wrote:

I want to total a column, subtract 1 particular cell from the total, and
take the total times 10%. I know it should be easy but......

FORMULA; ADD A COLUMN, SUBTRACT 1 CELL, TAKE THE TOTAL X 10%
 

=(SUM([range])-[cell])*.10

Example:

=(SUM(A1:A1000)-A50)*.10

Adjust to suit your needs.

Dave
--
Brevity is the soul of wit.


"Teresea" wrote:

I want to total a column, subtract 1 particular cell from the total, and
take the total times 10%. I know it should be easy but......

FORMULA; ADD A COLUMN, SUBTRACT 1 CELL, TAKE THE TOTAL X 10%
 

times, as in multiplication.
--
Brevity is the soul of wit.


"Jaleel" wrote:

What do you mean by total times?

"Teresea" wrote:

I want to total a column, subtract 1 particular cell from the total, and
take the total times 10%. I know it should be easy but......

FORMULA; ADD A COLUMN, SUBTRACT 1 CELL, TAKE THE TOTAL X 10%
 

=(SUM(A:A)-A30)*0.1


Gord Dibben MS Excel MVP

On Thu, 12 Oct 2006 09:42:02 -0700, Teresea
wrote:

I want to total a column, subtract 1 particular cell from the total, and
take the total times 10%. I know it should be easy but......