Assuming the data is in a1 to e1
=SUM(IF(--MID(A1:E1,3,LEN(A1:E1))<10,1,0))

This is an array formula that must be entered with ctrl|shift|enter

Note: there were only 2 entries under 10

Lance

"scottymelloty" wrote:


Hi,

Is it possible to count how many top 10's there have been in a row of
data that has text with the numbers ie:

jp5 ,, jp23 ,, as6 ,, as50 ,, as100 ,, 5 is this data was in a row on
the spreadsheet i want it to return that there were 3 entries that were
10 or under

someone gave me thsu formula to colour using conditional formatting for
a similar problem i had if that helps

=--MID(A1,MATCH(FALSE,ISERROR(--MID(A1,ROW(INDIRECT
("1:100")),1)),0),100-SUM(--ISERROR(--MID(A1,ROW(INDIRECT
("1:100")),1))))<11


--
scottymelloty
------------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...fo&userid=3808
View this thread: http://www.excelforum.com/showthread...hreadid=319314