i want to count how many times an entry occurs in an array

J

JCB

i am trying to count how many times a number has occured in the last 52 draws
of the lotto ( 6 numbrs + two supplementry numbers
 
J

Jacob Skaria

It would be helpful if you explain bit more about how your data is arranged.
Assuming you have the numbers in Col A and you want to know how many times
the numbers are there.

=COUNTIF(A:A,12345678)

If this post helps click Yes
 
Top