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.

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.

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.

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.