Excel word/number count

[ACarella]

I need to count all the words and numbers (ie, 40 CFR 261)

 

[Gary''s Student]

In A1 enter:

=COUNTA(B:IV,A2:A65536)

This will count all the cells containing words and numbers in versions of
Excel prior to 2007

 

[ACarella]

Would this be the same for a range, i.e., A2 through A350?

 

[Gary''s Student]

Yes, with this adjustment:

=COUNTA(A2:A350)