Thread: What formula is used for subtracting a range of different cells f.

What formula can I use for subtracting the values of a range of cells from an
initial cell value. I'd like to use an initial budget number and then itemize
as money is spent while at the same time having the budget number decrease as
more cell values (expenses) are added. I can add a range of cells, then put
that value in another cell (one formula), then I can take that sum and
subtract it from the starting budget number (second formula). I'm having
problems subtracting a range of cells from one cell with just one formula. I
thought I could use =A1-(A2:A10), meaning that the cell containing this
formula will subtract from A1 the values from A2 through A10. This ain't
flying. Any help appreciated.

"tim" <tim@discussions.microsoft.com> wrote in message
news:8F9950EA-18C2-430D-866F-EABC410A9900@microsoft.com...
> problems subtracting a range of cells from one cell with just one formula.
I
> thought I could use =A1-(A2:A10), meaning that the cell containing this
> formula will subtract from A1 the values from A2 through A10. This ain't
> flying. Any help appreciated.

You can use =A1-SUM(A2:A10)
to subtract the total of a2:a10 from A1.

use this instead
=A1-sum(A2:A10)


"tim" <tim@discussions.microsoft.com> wrote in message
news:8F9950EA-18C2-430D-866F-EABC410A9900@microsoft.com...
> What formula can I use for subtracting the values of a range of cells from
> an
> initial cell value. I'd like to use an initial budget number and then
> itemize
> as money is spent while at the same time having the budget number decrease
> as
> more cell values (expenses) are added. I can add a range of cells, then
> put
> that value in another cell (one formula), then I can take that sum and
> subtract it from the starting budget number (second formula). I'm having
> problems subtracting a range of cells from one cell with just one formula.
> I
> thought I could use =A1-(A2:A10), meaning that the cell containing this
> formula will subtract from A1 the values from A2 through A10. This ain't
> flying. Any help appreciated.