View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Joe M. Joe M. is offline
external usenet poster
 
Posts: 97
Default 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.