| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A way to count cells in a range containing text or formulas
I need to be able to count the number of cells in a range that contain
formulas and text; a way of counting anything within a cell including a null ("") return value. The range might be something like A1:Z100. Some of the cells within the range will be merged. Can you suggest a macro or formula (even better) for this. Thanks for your help in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count percentage of specific text in a range of cells | Excel Worksheet Functions | |||
| How do i count Text in the Cells, but not formulas. | Excel Discussion (Misc queries) | |||
| Dynamic Range in Excel that won't count formulas | Excel Discussion (Misc queries) | |||
| count specific text that occurs in a range of cells | Excel Discussion (Misc queries) | |||
| I need to count the occurence of text in a range of cells (which . | Excel Worksheet Functions | |||
Threaded Mode
