ADRIANA P
asked on
count number
is any way to count all the ocurrences of an number in the an list ??
COUNTDAT.xlsx
COUNTDAT.xlsx
ASKER
Roy_Cox thanks ! for you fast reponse
ASKER
what you mean dynamic??
I'm not sure what you are asking
ASKER
you bring 2 formulas why one give me 22 an other 228??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok i understand you mean 9 is 62 times
ASKER
great Job !
Pleased to help
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,"*"&