| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of cell which use if array function
Hi,
I have many cells using if function which result is number. I'd like to sum all of those cells, unfortunatelly i cant do that, the result is none. How can i solve this one? Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of cell which use if array function
If your IF formulas contain quotes around numbers, REMOVE THEM.
Wrong: =IF(A1="x","10","0") Right: =IF(A1="x",10,0) -- Biff Microsoft Excel MVP "Pran" wrote in message ... Hi, I have many cells using if function which result is number. I'd like to sum all of those cells, unfortunatelly i cant do that, the result is none. How can i solve this one? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| OR function in array-entered IF function | Excel Worksheet Functions | |||
| Function CELL in array formulas | Excel Discussion (Misc queries) | |||
| Code to determine if a cell contains an array function? | Excel Discussion (Misc queries) | |||
| How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
Hybrid Mode
