| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a Column - Net and Absolute Values
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing first 'n' values in a column or row | Excel Worksheet Functions | |||
| Summing values in a column if the date in another is of a certain month | Excel Worksheet Functions | |||
| summing last values in column | Excel Worksheet Functions | |||
| Summing one column if two other columns' values appear in other sh | Excel Worksheet Functions | |||
| sum absolute values of a column of numbers in Excel | Excel Worksheet Functions | |||
Threaded Mode
