Thread: FORMULA; ADD A COLUMN, SUBTRACT 1 CELL, TAKE THE TOTAL X 10%
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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......

Reply With QuoteReply With Quote