Hello everyone. Need some help with an Excel counting function; I figured it would be simple, but apparently it's not.
I need a total count of the numeric values in a column; some of the cells will have comma-separated entries, some will have single numerical entries, and some will have words.
For an example of data:
I need to count ONLY the numbers, including any zeroes, leaving out anything that is non-numeric. Some numbers may be repeated within the same cells. I also cannot separate out the numbers due to data organization needs.
So if I was counting the above example, my count output would be 9.
Any assistance would be appreciated.
I need a total count of the numeric values in a column; some of the cells will have comma-separated entries, some will have single numerical entries, and some will have words.
For an example of data:
- |
No data |
85, 93 |
100 |
85, 86 |
No data |
No data |
100 |
92, 0 |
95 |
I need to count ONLY the numbers, including any zeroes, leaving out anything that is non-numeric. Some numbers may be repeated within the same cells. I also cannot separate out the numbers due to data organization needs.
So if I was counting the above example, my count output would be 9.
Any assistance would be appreciated.