Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 83
Default count cells with data

what formula will count cells that contain any randmon data
text number, just basicly it will return a count for a range of cell
that are not empty
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default count cells with data

Sounds like you want the COUNTA function...

=COUNTA(C3:D500)

Just set the range reference as needed.

--
Rick (MVP - Excel)


" wrote in message
...
what formula will count cells that contain any randmon data
text number, just basicly it will return a count for a range of cell
that are not empty


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 83
Default count cells with data

nope, that counted the range.

I would like someithing that only counts the cells in the range that have
data and does not count the empty cells

"Rick Rothstein" wrote:

Sounds like you want the COUNTA function...

=COUNTA(C3:D500)

Just set the range reference as needed.

--
Rick (MVP - Excel)


" wrote in message
...
what formula will count cells that contain any randmon data
text number, just basicly it will return a count for a range of cell
that are not empty



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default count cells with data

=COUNTA(range)

Explanations of different types of COUNT functions are in help.


Gord Dibben MS Excel MVP

On Tue, 27 Jan 2009 13:59:01 -0800,
wrote:

what formula will count cells that contain any randmon data
text number, just basicly it will return a count for a range of cell
that are not empty


Reply
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
How to count all cells which have same data Judoguy Excel Discussion (Misc queries) 3 March 8th 07 11:38 PM
How to count all cells which have same data john Excel Discussion (Misc queries) 0 March 6th 07 10:24 AM
Count Only Empty Cells AFTER Cells with Data David Excel Worksheet Functions 2 September 15th 06 06:05 PM
Count data in cells DD Excel Worksheet Functions 3 June 7th 05 09:06 PM
Count cells with data shoiley New Users to Excel 5 November 28th 04 08:23 PM


All times are GMT +1. The time now is 07:02 PM.

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"