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?