Hello All,

I am trying to get a formula to calculate the percentage of times a particular number shows up in a selection of cells. For example if my cells look like this:
1
1
1
2
1
2
1
2
1
1
(Formula here for the number of times 1 shows up as a percentage of total numbers in that range) answer=70%

I have to do this literally thousands of times so I would like a formula I can just copy and paste instead of having to put the cell range in by hand each time.

Many many thanks in advance for your help!
Cheers,
Serene