Hey my name is Jay, I am currently trying to average the number of times each
number 1-47 occurs in cells A1-E74

e.g.
1 1 1 1
2 2 2 2
3 3 3 3
4 6 5 7
2 1 4 6

Frequency of the number 1 = 5

I have tried the frequency option but it includes ALL the numbers one, even
the 1's in the double digits.

e.g.
1 2 4 5
21 3 41 5

It says 1 = 3

I have tried adding a * to the number. Still nothing.

e.g.
=FREQUENCY(A1:E74,1*)