| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I subtract using formulas?
I want to subtract multiple cells.
Can I shorten this equation? B1-B5-B6-B7-B8-B9-B10-B11 |
|
#2
|
|||
|
|||
|
How do I subtract using formulas?
=B1 - sum(B5:B11)
should do the trick |
|
#3
|
|||
|
|||
|
How do I subtract using formulas?
=B1-SUM(B5:B11)
"Vanessa" wrote: I want to subtract multiple cells. Can I shorten this equation? B1-B5-B6-B7-B8-B9-B10-B11 |
|
#4
|
|||
|
|||
|
How do I subtract using formulas?
Thank you!
"mbarron" wrote: =B1 - sum(B5:B11) should do the trick |
|
#5
|
|||
|
|||
|
How do I subtract using formulas?
Thank you!
"JMB" wrote: =B1-SUM(B5:B11) "Vanessa" wrote: I want to subtract multiple cells. Can I shorten this equation? B1-B5-B6-B7-B8-B9-B10-B11 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| Formulas | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
