View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
William Horton
 
Posts: n/a
Default Creating Formulas

=SUM(K1:K3)-SUM(K7:K9)

Put the above formula in "another cell".

Add's cells K1:K3 and then subtracts from that total the sum of cells K7:K9.

"Lucille" wrote:

Adding several cells and then subtracting several cell from that total, and
showing the result in another cell?
--
LP051354