Counting cells containing formulas with blank results

J

Joe M.

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.
 
J

Joe M.

Continued: I only need the non-blank values counted. Can anyone help?
Thanks,
Joe M.
 
P

PCLIVE

Possibly try using SUMPRODUCT. You'll need to specify the rows.

=SUMPRODUCT(--('CM(Sched)'!AQ1:AQ100<>""))

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using LEFT() in COUNTIF 2
How to count blank cells that contain formula? 5
Count with merged cells 2
Counting non-blank cells 7
Count of visible, non-blank cells only? 8
Using COUNTA and excluding formulas that gives zero or blank cells 3
Counting cells by font color 2
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1

Top