columns with text

fourcag

New Member
Joined
Nov 22, 2005
Messages
1
I have a spreadsheet with many columns with text only. Is there a way to show me at the bottom of each row how many of my columns contain text? Some of them are blank and I want to be able to look and see how many contain text. Thank you.
 

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
worksheet functions
=COUNTA() counts nonblank cells
=COUNTBLANK() counts blanks
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,044
When you say "bottom of each row", do you mean "bottom of each column"? If the cells have had the text typed ( as opposed to all cells containing formulae, some of which look blank ), then use the COUNTA function to count how many cells in a range are non-blank.
 

Forum statistics

Threads
1,078,406
Messages
5,340,041
Members
399,348
Latest member
duel

Some videos you may like

This Week's Hot Topics

Top