"tim" wrote in message
...
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.
|