subtraction

Copper Contributor

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.