ExcelBanter - Is there a way to subtract a column of numbers?

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

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

- - Is there a way to subtract a column of numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/176388-there-way-subtract-column-numbers.html)

computerkiller

Is there a way to subtract a column of numbers?

I normal subract a column this way, =b1-b2-b3-b4-b5-b6, but that is tedious.
Is there another way?

yshridhar

Is there a way to subtract a column of numbers?

Try
=B1-Sum(b2:b6)
With regards
Sreedhar

"computerkiller" wrote:

I normal subract a column this way, =b1-b2-b3-b4-b5-b6, but that is tedious.
Is there another way?

All times are GMT +1. The time now is 05:02 AM.