| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I substract numbers in range like this: Substract(a1..a10)
|
|
#2
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get a count of numbers whose value falls within a given range | Excel Worksheet Functions | |||
| Find Median of Positive numbers only in Range | Excel Worksheet Functions | |||
| Lookup a range of numbers | Excel Discussion (Misc queries) | |||
| occurance of numbers in cell range | Excel Worksheet Functions | |||
| How do I create formula to count numbers in a range of cells? | Excel Worksheet Functions | |||
Hybrid Mode
