New mbr needs immediate help with formula.

K

knacctg

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.
 
C

CLR

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

=A1-SUM(B1:G1)

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

Vaya con Dios,
Chuck, CABGx3
 
Top