Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
martins
 
Posts: n/a
Default Counta


I am using COUNTA to count data in a range of cells - the data in this
instance is dates formatted as say Jan-06 - should work ok except that
the formula is also counting cells which maybe blank but contain other
formulas - what do I need to do to just return a result for the data as
specified?


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=529414

 
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
counta function can any one explain the example counting 2 pete the greek Excel Discussion (Misc queries) 4 March 30th 06 10:27 AM
Insert New Rows based on COUNTA() TheDPQ New Users to Excel 2 January 28th 06 03:07 AM
COUNTA, COUNTIF? Newbie Excel Worksheet Functions 1 March 18th 05 11:33 AM
Unable to Copy COUNTA() with cell references EugenioB Excel Worksheet Functions 1 February 16th 05 01:07 PM
COUNTA Function not working =COUNTA(C3:C69,"NH") MikeinNH Excel Worksheet Functions 2 November 8th 04 01:19 AM


All times are GMT +1. The time now is 08:03 PM.

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"