B
BRob
I've got a column of positive and negative numbers that I want to total in
two ways :
- net - ie just natural addition which I can do with the SUM formulae
- absolute - ie the total being based on an assumption that all numbers are
positive
A slightly messy way (because of the design of the spreadsheet) is to create
an extra column of absolute values and sum that.
So my question is 'Is there are formulae I can use to do an absolute sum on
those values directly?'
TIA
Rob
two ways :
- net - ie just natural addition which I can do with the SUM formulae
- absolute - ie the total being based on an assumption that all numbers are
positive
A slightly messy way (because of the design of the spreadsheet) is to create
an extra column of absolute values and sum that.
So my question is 'Is there are formulae I can use to do an absolute sum on
those values directly?'
TIA
Rob