| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Confusing Problem
I have a cell with an equation: [=sum(if(sheet1A1:A100,1,0))] in sheet1 cells A1:A10, I have a second equations that says: =if(B1=0,"",C1) The problem is the first sum function counts the cells with the "" as being a number that is greater than zero. However, if I manually delete the information in the cells that had a "" entered from the second equation, I noticed it does not count the cell as being greater than zero. Why does Excel consider the value of a cell to be greater than zero when the contents of the cell are blank from the second equation. How do I get Excel to not consider this to be greater than zero? -- Cincy ------------------------------------------------------------------------ Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172 View this thread: http://www.excelforum.com/showthread...hreadid=561217 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have some problem with database | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
