Count number of values in a cell

[Guest]

This should be SO simple, but I just can't figure it out!
I've got a column in which each cell has a different list of numbers
separated by commas. I need to count how many numbers in a cell are greater
than or equal to 15:

4,14,16,15,15.3 --> 3
10,10.5,14.9 --> 0
19, 15.1, 15 -->2

Anybody got any ideas??? Thanks for your help!

 

[Guest]

that last row had an error of course....

This should be SO simple, but I just can't figure it out!
I've got a column in which each cell has a different list of numbers
separated by commas. I need to count how many numbers in a cell are greater
than or equal to 15:

4,14,16,15,15.3 --> 3
10,10.5,14.9 --> 0
19,15.1 -->2

Anybody got any ideas??? Thanks for your help!

 

[Anne Troy]

Sorry, Doc. I don't know why you think it should be simple. Excel wants the
values in different cells. Matter of fact, if you insert a column to the
left, and then select this column and do a Data-->Text to columns and split
this cell up by it's numbers, you could then use a formula like the
following in the inserted column:
=COUNTIF(B2:IV2,">15")
*******************
~Anne Troy

www.OfficeArticles.com

 

[Guest]

Thanks Anne. you're absolutely right, that would make it much easier - to
separate the data into separate columns, and if I must I will. But I don't
want to clutter the spreadsheet too much (some cells will have hundreds of
numbers) and don't like refering to separate sheets.... because it will go
through different hand and a separate worksheet might get accidentally
separated. Thanks for the quick reply!