It's really important that you present your exact structure and what you
want to do in your first post. Otherwise, you could have many talented
people wasting their time solving a problem you don't have.

That being said...
try one of these:
=SUMPRODUCT(ISNUMBER(MATCH(ROW(B4:AH83),
{4,7,9,11,14,16,18,22,25,35,46,57,68,72,83},0))*
ISNUMBER(B4:AH83))

or
=COUNT(INDEX(MATCH(ROW(B4:AH83),
{4,7,9,11,14,16,18,22,25,35,46,57,68,72,83},0)/
ISNUMBER(B4:AH83),0))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"ytayta555" wrote in message
...
I have a big problem !
I have many functions which have the arguments in this way ,
foe example :
=COUNT(B4;B7;B9;B11;B14;B16;B18;B22;B25;B35;B46;B5 7;B68;B72;B83)
I mean the rows are not in continuous mode ;
What I can do in this case ? Please for help !

I have a database of 231 with 15,000,000 count functions
with the references in combinatoric order ! I use it for ....
lotto statistic .
Many thanks again