software

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

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

Put the above formula in quot;another cellquot;.

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

quot;Lucillequot; wrote:

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

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 gt;
wrote:

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