Input editing and summing greater than space

[Art]

Hi -

I have two things that I need some help with fi anyone
has the answers.

First - I have a column M9:M53 where if any of the cells
aren't empty I'd like to count them as a +1. Example:
Cells M9, M15,and M36 have a text value in them - then
the total at the foot of the column (M54) should equal 3.

Second - I have a few columns where text values are
entered upon specific conditions. What I'd like to do is
edit the input so as to ensure that the individual cells
in the column are empty UNLESS one of the specific text
values is entered. I'm just trying to make it impossible
to enter incorrect text into each individual cell. Any
thoughts?

Thanks in advance for your assistance.

Art

 

[CLR]

=COUNTA(M9:M53) will count all the cells with text in them that are in the
range.

Your second item sounds like you should investigate the Data > Validation >
Allow: list feature so the users won't have to guess what text you want,
they can just select it from the list......

hth
Vaya con Dios,
Chuck, CABGx3

 

[J.E. McGimpsey]

One way:

First: =COUNTA(M9:M53)

Second: Check out Validation in XL HELP. You can establish a
list of entries that will be accepted, either directly in the dialog
or by referring to a range with those entries.