Thread: How do I substract numbers in range like this: Substract(a1..a10)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Paulo
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote