| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count cells with numbers and ignore cells with errors
There are ways to easily do what you want but you should correct your
formulas so that they don't happen. -- Don Guillett SalesAid Software "WonderingaboutMicrosoft" wrote in message ... I want to count the cells with numeric values and ignore the cells that contain #DIV/0! in Office 2007 Beta BTR. I have tried countif, countifs, and several other formulas. I have tried setting the cells to TRUE and FALSE and counting numeric values but nothing seems to work. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average only cells that contain numbers | Excel Worksheet Functions | |||
| add numbers in different cells , but ignore cell with #VALUE! to t | Excel Worksheet Functions | |||
| Ignore Text in Cells Referenced in a formula | Excel Discussion (Misc queries) | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
| Formula to ignore negative numbers in a column? | Excel Worksheet Functions | |||
Hybrid Mode
