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.