Excel Help Needed

How does one figure out a frequency number in excel??

example

No.---Times hit
0-----8
1-----4
3-----6
2-----1
3-----7
4-----0
5-----2
6-----8
7-----5
8-----3
9-----1
total 45---Hits

Do you divide hits into total hits to find the frequency??
example ---to find out the number say 3 it hit 7 times do
you divide 7/45  ???? to get the frequency????
Need some excel help.....
Thank you
Bob in Michigan
learning excel slow but sure----

Divde number of draws by number of hits= avg

example

45/3=15

#DIV/0! 4
45.00-- 9
22.50-- 5
15.00-- 8
11.25-- 1
9.00--- 7
7.50--- 2
6.43--- 3
5.63--- 0
5.63--- 6
Total--45 hits
ok got it and thank you carBob----but I get a #DIV/0! on the 4
because they were no hits...?????thats normall???
Would the 4 go on the bottom ???
Thanks again CARBOB

Bob in Michigan

times a number hit / total hits

0/45 = 0

Getting kind of confused here-----

CarBob puts it 45/3

Time*treat puts it 0/45

I am just learning myself but thinking that carbob is the way to go--

Hits total / divided by Hits

Example ----- if the number 5 had 8 Hits and the total was 45 hits

than you would take 45 /divided by  8--------------45/8==5.62

Hope that is right---

Thanks

Bob in Michigan

If you want the Frequency over a Period of Time (Last 20 Draws) use the =countif Function over the selected Range of Addresses (Period of Time) for each Digit (0 to 9).

OK thanks to all that answed-----

If I can see an example than thats when it sticks in my mind----

Anyway thanks

Bob in Michigan