Formula for text

[robyn_bell]

Hi - I am wanting to work out the total of rows with data in a particlar column. These rows do not have #'s in them (just text), so the outcome is simply a total of rows with data. If anyone could help, I'd appreciate it. I have various book lists, and am wanting a quick total of how many books in each list (Column).
Many thanks, Robyn

 

[VoG]

Hello and welcome to MrExcel.

Try

=COUNTA(A:A)

to count the values in column A.

 

[robyn_bell]

Thank you very much. That was perfect!