subtract a range from an added range

Marge · Nov 20, 2008

I want to add cells A1

1 then subtract the sum of cells A2

2 to get a total
and I can't get it to work. Please help!

Mike H · Nov 20, 2008

Marge,

Try this

=SUM(A1

1)-SUM(A2

2)

Mike

Marge · Nov 20, 2008

You rock! Thanks very much.

Mike H said:
Marge,

Try this

=SUM(A11)-SUM(A22)

Mike