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

  • Thread starter Thread starter Guest
  • Start date Start date
depends on what you mean...

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



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)
 
Try

=A1-SUM(A2:A3)

Regards
Rowan
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)


:
Click to expand...
 
Back
Top