View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
LAS LAS is offline
external usenet poster
 
Posts: 3
Default Count number of text rows???

Thanks so much!!!
That's not in the list of any of the formulas on the formula tab that I can
see. Should I have been able to find this myself?
I'm using Excel 2010

"Claus Busch" wrote in message ...

Hi,

Am Mon, 3 Sep 2012 20:05:05 -0400 schrieb LAS:

Example

First Name Last Name
Alma Diderot
Mark Woolser
Amy Fleisher
Count 3


try:
=COUNTA(A:A)-1
-1 for the header


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2