How do I count cells with text in them?

[Guest]

I just want to count the number of cells in a row that contain text. Some
cells will be empty and others will contain a text such as HNOV03, which
identifies a crate. A row of cells could have only one crate or it could
list several. I could continue to count them manually and insert the sum,
but I keep forgetting. If there were a formula in the form it would always
have the correct sum.

TIA,

Dave

 

[Guest]

Try COUNTA function:

e.g =COUNTA(3:3) will count cells not empty in row 3

 

[Vito]

=Counta(A1:Z1), where A1:Z1 is the row range you're looking at

 

[Vito]

=Counta(A1:Z1), where A1:Z1 is the row range you're looking at

 

[Guest]

Toppers,

This almost works, but I found I also need the letter reference for the
cells to be counted.

Thanks this is a big help. Why didn't they put this in the Help index?
Microsoft always makes things difficult.

Dave