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

=B1 - sum(B5:B11)

should do the trick

=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

Thank you!

"mbarron" wrote:

> =B1 - sum(B5:B11)
>
> should do the trick
>
>

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