| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multipule calculations in a single column
Trying to total sum a range of cells in a column and subtract from a total in
another cell in the same column, getting a value error ex sum cell a10 to a20 then subtract from the number in a5 excel 2007 -- Max |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multipule calculations in a single column
Hi there.
You may want to try: =SUM(A10:A20)-IF(ISNUMBER(A5),A5,0) Anyway, you should be sure that the value in A5 IS a number and not a string/text that 'SEEMS' to be a number. Tip: text/string are left aligned by default. Regards, Otávio "mexmex" wrote: Trying to total sum a range of cells in a column and subtract from a total in another cell in the same column, getting a value error ex sum cell a10 to a20 then subtract from the number in a5 excel 2007 -- Max |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multipule calculations in a single column
Shouldnt be the other way around ?
=VALUE(A5)-SUM(A10:A20) Is your sum() returning an error? Then check whether any of the cells in the sum range is having error. If all are positive try =SUMIF(A10:A20,"0") or if both try (array entered) =SUM(IF(ISNUMBER(A10:A20),A10:A20)) or =SUMIF(A10:A20,"0")+SUMIF(A10:A20,"<0") "Otávio Alves Ribeiro" wrote: Hi there. You may want to try: =SUM(A10:A20)-IF(ISNUMBER(A5),A5,0) Anyway, you should be sure that the value in A5 IS a number and not a string/text that 'SEEMS' to be a number. Tip: text/string are left aligned by default. Regards, Otávio "mexmex" wrote: Trying to total sum a range of cells in a column and subtract from a total in another cell in the same column, getting a value error ex sum cell a10 to a20 then subtract from the number in a5 excel 2007 -- Max |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multipule vlookups | Excel Discussion (Misc queries) | |||
| From single cell variables to a single column serie | New Users to Excel | |||
| Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
| Linking data to a single cell for calculations | Excel Discussion (Misc queries) | |||
| Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
Hybrid Mode
