| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to subtract a column of numbers?
I normal subract a column this way, =b1-b2-b3-b4-b5-b6, but that is tedious.
Is there another way? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to subtract a column of numbers?
Try
=B1-Sum(b2:b6) With regards Sreedhar "computerkiller" wrote: I normal subract a column this way, =b1-b2-b3-b4-b5-b6, but that is tedious. Is there another way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to subtract a range of numbers | Excel Worksheet Functions | |||
| Subtract numbers | Excel Discussion (Misc queries) | |||
| Increment and subtract Numbers | Excel Worksheet Functions | |||
| subtract 3 numbers and 2 cells | New Users to Excel | |||
| How to subtract two numbers in excel ? | Excel Worksheet Functions | |||
Hybrid Mode
