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

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
>

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