Forum Discussion
subtraction
How do I subtract many cells (in one column) from the total (in same column)? What is the formula? Thank you!
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.
=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.