| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 8211 | 2001-03-12 09:55:00 | MS excel text counting | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 9890 | 2001-03-12 09:55:00 | if you have a column of text.. ie peoples names for ex, how do you get a count of how many cells that text has taken up. there can be blank cells mixed in, but we don't want a count of these. Now an easy way is to sort and then just get the column count on the side, but I don't want the order of the data counted with, to be altered. So it would be just like a sum for numbers, but in this case for the number of cells that contain values of any sort. Is there a way to do this inside of a spreadsheet? (no VB) thanks |
Guest (0) | ||
| 9891 | 2001-03-12 10:27:00 | gizzy, use the =counta function. eg. =counta(b5:b10) will count all the non empty cells in that range. | Guest (0) | ||
| 1 | |||||