... If I have text in a cell, can I use "COUNT"...

G

Guest

I am creating an audit sheet. I have 5 columns labled 0, 1, 2, 3-4, 5+. In
the cells below these labels I want to place "X"'s to indicate the number of
incedences corisponding to the number in the labels.

Can I use the COUNT function to record the number of "X"'s in the range of
cells? (The COUNT Function works is I place numbers in the cells but doesn't
seem to work if I have text in the cells.)

Tnak you,
Darrell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count until blank cell 2
Count max consecutive cells 2
... Count Function ... with any character ... 4
count if and 4
Count if based on criteria within cells on another sheet 1
Count with merged cells 2
Count Formula Need Help! 1
cell totals 4

Top