I have a column of numbers and would like to know the total after everybody has paid me back, but I have negative numbers currently in there:
So the total of this should be
95, currently if I do a sum it will be
This is what I currently have:
but this doesn't work of course as it does it on the total of all the rows within the range in the column.