aDD AND SUBTRACT WITHIN THE SAME RANGE

[kuecker2]

I am rusty as all get out so forgive me for the question. I have a range of cells a1 - z50. I want to add them all in a range. but I also want to deduct a column within that range C1 to C50.

 

[Leith Ross]

Hello kuecker2,

One way is ...

=SUM(A1:Z50)-SUM(C1:C50)