Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with "SUM" AND "ABS" in same formula
The cells in a SUM formula all include formulas that provide the cells with
negative numbers, positive numbers and blank cells. Need to have the respective values to be used in another formula as absolute values. Need to have the negative values in the range to stay displayed as negatives and the blank cells in the range to stay displayed as blank. Tried using =sum(abs(range)), which works fine if the blank cells are omitted from the range. If the blank cells are part of the range the result is "#VALUE!". Is there something to add to resolve the error message? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |