Reply to thread

Message: [QUOTE="Art, post: 3439131"] 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 [/QUOTE]