LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 97
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing cells with formulas results in blank cell. rdp Excel Worksheet Functions 1 December 4th 07 06:53 PM
Results from blank linked cells Mr. Anolog New Users to Excel 2 October 21st 06 03:08 PM
OLAP Blank results in CUBEMEMBER and CUBECELL Formulas sansimeon Excel Discussion (Misc queries) 0 October 4th 06 06:21 AM
Counting Non Blank Cells that Contain Formulas jimswinder Excel Worksheet Functions 1 July 21st 06 11:36 PM
counting cells in two columns that have the same results Chris Excel Worksheet Functions 8 May 18th 06 09:19 PM


All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"