Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Naz
 
Posts: n/a
Default Character Count Range of Cells

You could use

{=SUM(LEN(A1:A20))}
Note that the curly brackets indicate an Array formula DO NOT type them
simply type

=SUM(LEN(A1:A20))

and the prest Ctrl+Shift+Return the formula will be entered and the
brackets as well.

Change the range to suit



--

_______________________
Naz,
London


"michimac" wrote:

How can I get a character count for text in a large range of cells in a
worksheet? I can only get LEN to count a single cell without a #VALUE!
error.
--
michimac

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
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 8 May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 0 May 15th 05 08:14 PM
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN carricka Excel Worksheet Functions 1 May 6th 05 04:50 PM
Formula to count the cells in a range that have a fill color. Slainteva Excel Discussion (Misc queries) 2 January 19th 05 09:25 PM
How can I dynamically eliminate blank cells in a given range in E. Scott Steele Excel Worksheet Functions 6 December 17th 04 04:23 AM


All times are GMT +1. The time now is 10:14 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"