LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrp mrp is offline
external usenet poster
 
Posts: 2
Default COUNTA ----- FORMULA WILL NOT COUNT NON BLANK CELLS

when entering
=COUNTA(C9:C78) into a cell to count the non blank cells the formula is
displayed instead of the count.

Any suggestions as to how to resolve the problem would be appreciated
--
Al
 
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
Befuddled by Count blank cells Formula! [email protected] Excel Worksheet Functions 2 May 29th 07 09:01 PM
How to count blank cells that contain formula? IntricateFool Excel Discussion (Misc queries) 5 June 8th 06 02:45 PM
Errors in COUNT, COUNTA, COUNTIF when counting merged cells Outback Excel Worksheet Functions 1 February 7th 06 04:29 PM
how can I count blank cells as a zero, when using formula please?? Ted Excel Worksheet Functions 5 November 22nd 05 06:14 PM
formula to count cells not blanK pmarques Excel Worksheet Functions 4 August 3rd 05 01:44 PM


All times are GMT +1. The time now is 08:48 AM.

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

About Us

"It's about Microsoft Excel"