Count number of values in a cell
 

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!

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!

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


"nyc_doc" wrote in message
...
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!

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!


"Anne Troy" wrote:

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


"nyc_doc" wrote in message
...
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!