| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells containing formulas with blank results
Im trying to use =COUNTA('CM(Sched)'!AQ:AQ) to count non-blank cells in AQ.
The cells contain a formula which sometimes results in BLANK. The formula counts all cells including blank. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells containing formulas with blank results
Continued: I only need the non-blank values counted. Can anyone help?
Thanks, Joe M. "Joe M." wrote: Im trying to use =COUNTA('CM(Sched)'!AQ:AQ) to count non-blank cells in AQ. The cells contain a formula which sometimes results in BLANK. The formula counts all cells including blank. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells containing formulas with blank results
Possibly try using SUMPRODUCT. You'll need to specify the rows.
=SUMPRODUCT(--('CM(Sched)'!AQ1:AQ100<"")) HTH, Paul -- "Joe M." wrote in message ... Im trying to use =COUNTA('CM(Sched)'!AQ:AQ) to count non-blank cells in AQ. The cells contain a formula which sometimes results in BLANK. The formula counts all cells including blank. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting cells containing formulas with blank results
You could use =ROWS('CM(Sched)'!AQ:AQ)-COUNTIF('CM(Sched)'!AQ:AQ,"")
Tyro "Joe M." wrote in message ... Im trying to use =COUNTA('CM(Sched)'!AQ:AQ) to count non-blank cells in AQ. The cells contain a formula which sometimes results in BLANK. The formula counts all cells including blank. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing cells with formulas results in blank cell. | Excel Worksheet Functions | |||
| Results from blank linked cells | New Users to Excel | |||
| OLAP Blank results in CUBEMEMBER and CUBECELL Formulas | Excel Discussion (Misc queries) | |||
| Counting Non Blank Cells that Contain Formulas | Excel Worksheet Functions | |||
| counting cells in two columns that have the same results | Excel Worksheet Functions | |||
Linear Mode
