ExcelBanter - subtract a range from an added range

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - subtract a range from an added range (https://www.excelbanter.com/excel-discussion-misc-queries/211134-subtract-range-added-range.html)

Marge

subtract a range from an added range

I want to add cells A1:D1 then subtract the sum of cells A2:D2 to get a total
and I can't get it to work. Please help!

Mike H

subtract a range from an added range

Marge,

Try this

=SUM(A1:D1)-SUM(A2:D2)

Mike

"Marge" wrote:

I want to add cells A1:D1 then subtract the sum of cells A2:D2 to get a total
and I can't get it to work. Please help!

Marge

subtract a range from an added range

You rock! Thanks very much.

"Mike H" wrote:

Marge,

Try this

=SUM(A1:D1)-SUM(A2:D2)

Mike

"Marge" wrote:

I want to add cells A1:D1 then subtract the sum of cells A2:D2 to get a total
and I can't get it to work. Please help!

All times are GMT +1. The time now is 06:54 AM.