ExcelBanter - Creating Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Creating Formulas (https://www.excelbanter.com/excel-worksheet-functions/85481-creating-formulas.html)

Lucille

Creating Formulas

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

William Horton

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

Gord Dibben

Creating Formulas

Lucille

Assuming cells with numbers are A1:A10

in B1 enter =SUM(A1:A10)-SUM(A2,A5,A6,A9)

Gord Dibben MS Excel MVP

On Wed, 26 Apr 2006 11:39:01 -0700, Lucille
wrote:

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

All times are GMT +1. The time now is 02:22 PM.