Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

count number

is any way to count all the ocurrences of an number in the an list ??
COUNTDAT.xlsx
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Your numbers aren't numbers, they are stored as text. This is possibly not an issue for you.

Do you mean something like this

=COUNTIF(G17:G265,"*9*")

You can make this dynamic by putting the number in a cell

=COUNTIF($G$17:$G$265,"*"&J13&"*")
Avatar of ADRIANA P

ASKER

Roy_Cox  thanks ! for you fast reponse
why is 22 and other 228??User generated image
what you mean dynamic??
I'm not sure what you are asking
you bring 2 formulas why one give me 22 an other 228??
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok i understand  you mean 9 is 62 times
great Job !
Pleased to help