ExcelBanter - How do I substract numbers in range like this: Substract(a1..a10)

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I substract numbers in range like this: Substract(a1..a10) (https://www.excelbanter.com/new-users-excel/55409-how-do-i-substract-numbers-range-like-substract-a1-a10.html)

Paulo

How do I substract numbers in range like this: Substract(a1..a10)

Dave Peterson

How do I substract numbers in range like this: Substract(a1..a10)

depends on what you mean...

Maybe:
=-sum(a1:a10)
or
maybe:
a1-sum(a2:a10)

Paulo wrote:

--

Dave Peterson

Paulo

How do I substract numbers in range like this: Substract(a1..a

For example: to add I do this
a1 1.00 +
a2 2.00 +
a3 3.00 +
a4 6.00 (total) =sum(a1:a3)
I want to do this
a1 6.00 -
a2 1.00 -
a3 1.00 -
a4 4.00 (total) =?(a1:a3)

"Dave Peterson" wrote:

depends on what you mean...

Maybe:
=-sum(a1:a10)
or
maybe:
a1-sum(a2:a10)

Paulo wrote:

--

Dave Peterson

Rowan Drummond

How do I substract numbers in range like this: Substract(a1..a

Try

=A1-SUM(A2:A3)

Regards
Rowan

Paulo wrote:
For example: to add I do this
a1 1.00 +
a2 2.00 +
a3 3.00 +
a4 6.00 (total) =sum(a1:a3)
I want to do this
a1 6.00 -
a2 1.00 -
a3 1.00 -
a4 4.00 (total) =?(a1:a3)

"Dave Peterson" wrote:

depends on what you mean...

Maybe:
=-sum(a1:a10)
or
maybe:
a1-sum(a2:a10)

Paulo wrote:

--

Dave Peterson

All times are GMT +1. The time now is 04:52 AM.