| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Negative values in a formula
How do you enter a formula to add the value of cells in a column, but minus
negative values in the column? Susan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Negative values in a formula
trY:
=SUMIF(A1:A50,"0") "Susan" wrote: How do you enter a formula to add the value of cells in a column, but minus negative values in the column? Susan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Negative values in a formula
Do you mean that when you add the numbers you want to treat the negative
numbers as zero, or that you want to treat them as positive (and take the absolute value)? -- David Biddulph "Susan" wrote in message ... How do you enter a formula to add the value of cells in a column, but minus negative values in the column? Susan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for parenthesis round negative money values in excel | Excel Worksheet Functions | |||
| negative values | Excel Discussion (Misc queries) | |||
| how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
Hybrid Mode
