| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Auto Sum numeric results from an IF/THEN equation?
I have an if then statement that returns numeric results. I would like to be
able to sum up the list of results but Excel returns a " - ". I believe it is because the sum tool ignores logical equations but there has to be a way around it. Thanks for any help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I Auto Sum numeric results from an IF/THEN equation?
I have an if then statement that returns numeric results.
I would like to be able to sum up the list of results but Excel returns a " - ". Sounds like you have the sum cell formatted as Accounting and the dash represents 0. So, that probably means the results of your IF formulas are returning TEXT and not numbers. Do your IF formulas have any numbers enclosed in quotes? Something like this: =IF(A1="foo","10","0") If so, remove the quotes from around the numbers: =IF(A1="foo",10,0) Enclosing numbers in quotes like that makes them TEXT. -- Biff Microsoft Excel MVP "mstrausz" wrote in message ... I have an if then statement that returns numeric results. I would like to be able to sum up the list of results but Excel returns a " - ". I believe it is because the sum tool ignores logical equations but there has to be a way around it. Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| equation as text string and its numeric result | Excel Discussion (Misc queries) | |||
| Returning Numeric Results across a Single Row in Consecutive Cells | Excel Worksheet Functions | |||
| change excel auto column headers from numeric to alpha | Excel Discussion (Misc queries) | |||
| Sum the results of an equation through a series of Cells | Excel Worksheet Functions | |||
| Equation giving unexpected results | Charts and Charting in Excel | |||
Linear Mode
