ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I subtract using formulas? (https://www.excelbanter.com/excel-worksheet-functions/55208-how-do-i-subtract-using-formulas.html)

Vanessa
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

mbarron
How do I subtract using formulas?
 
=B1 - sum(B5:B11)

should do the trick

JMB
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

Vanessa
How do I subtract using formulas?
 
Thank you!

"mbarron" wrote:

=B1 - sum(B5:B11)

should do the trick

Vanessa
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


All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com