View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Arguments Count Function problem

Amended formula:
=COUNT(B46:AH58,B62:AH63)

Does that help?

Regards,

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

"Ron Coderre" wrote in message
...
Try this:

=COUNT(B46:C58,B62:C63,AH46:AH58,AH62:AH63)

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

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

"ytayta555" wrote in message
...
Hi everybody

I have 33 Count functions :

=COUNT(B46;B47;B48;B49;B50;B51;B52;B53;B54;B55;B56 ;B57;B58;B62;B63),
=COUNT(C46;C47;C48;C49;C50;C51;C52;C53;C54;C55;C56 ;C57;C58;C62;C63),
....................
=COUNT(AH46;AH47;AH48;AH49;AH50;AH51;AH52;AH53;AH5 4;AH55;AH56;AH57;AH58;AH62;AH63)

How must look this function to have the same rows number , but to
count 33
columns , from B to AH ??
This 33 functions , can be in only one ??

Please very much to help !