how to set up subtraction formula in excel

The balance is then some initial value less the sum of amounts for that person. You want to have a single row of balances for each of the people. Let's assume that Columns A and B continue on down the sheet, with further name + amount entries. Would there be a way to constrain the formula to a single cell so I can have the total in a single location rather than down the columns? My plan is to have the total boxes scroll with the sheet and always be visible.

Any assistance would be greatly appreciated! Is there a simple method I can use to generate this result? Also thought about changing the formatting of a cell based on the name in the cell next to it and subtracting the value of any cell with that colour but this becomes unwieldy if names are added. So to pseudo-code it: read(column B cell) Įlse if(column B cell - 1 column = 'Jim') Is there a formula I can use that will read column B and subtract the amount shown from the correct column based on the name in column A? I've had some trouble figuring it out and tried to use conditional formatting to solve it but can't seem to quite get there.

I would like the values in columns K, L, and M to read from column B, detect if the corresponding cell from A reads one of 'Tom', 'Jim', or 'Dave' for example, and then subtract the amount from the correct column to reduce a running total.

How to set up subtraction formula in excel