How do I count cells with text in them?

D

Dave McCuen

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
 
D

Dave McCuen

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
 
Top