| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A way to count cells in a range containing text or formulas
On Mon, 18 Jul 2011 15:08:33 -0700 (PDT), Michael Lanier wrote:
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. =SUMPRODUCT(--NOT(ISBLANK(A1:Z100))) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A way to count cells in a range containing text or formulas
Thanks Ron. Your help is much appreciated.
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A way to count cells in a range containing text or formulas
On Thu, 21 Jul 2011 10:59:03 -0700 (PDT), Michael Lanier wrote:
Thanks Ron. Your help is much appreciated. Glad to help. Thanks for the feedback. |
| Reply |
| 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 | |||
Linear Mode
