Forum Discussion
subtraction
How do I subtract many cells (in one column) from the total (in same column)?
What is the formula? Thank you!
1 Reply
- in the most simple of cases and with dynamic arrays (Excel 365) you can just:
=total-range
for example if the column of values are A1:A9 and the total is in A10 then:
=$A$10 - $A$1:$A$9
if you have more specific issues please explain and if possible share a worksheet or include a sample table.
