New mbr needs immediate help with formula.
 

I am trying to do a seemingly simple formula - but getting only errors!


All I want to do is enter a formula that takes one cell and subtracts a
subsequent range of other cells in the same row!

The destination cell is also in the same row, but obviously not in the
range.

I am trying to meet a deadline and am going nuts trying to figure this
out - someone please help me.


--
knacctg
------------------------------------------------------------------------
knacctg's Profile: http://www.excelforum.com/member.php...o&userid=24669
View this thread: http://www.excelforum.com/showthread...hreadid=382438

In the destination cell, put..........

=A1-SUM(B1:G1)

Change the cell addresses per your requirements.......

Vaya con Dios,
Chuck, CABGx3


"knacctg" wrote in
message ...

I am trying to do a seemingly simple formula - but getting only errors!


All I want to do is enter a formula that takes one cell and subtracts a
subsequent range of other cells in the same row!

The destination cell is also in the same row, but obviously not in the
range.

I am trying to meet a deadline and am going nuts trying to figure this
out - someone please help me.


--
knacctg
------------------------------------------------------------------------
knacctg's Profile:
http://www.excelforum.com/member.php...o&userid=24669
View this thread: http://www.excelforum.com/showthread...hreadid=382438