How do I find the mean of categorical data?

here is my problem:

I am doing this lab on streaks in basketball, like 0=miss, 1=hit once, 2= hit two in a row.. so on.

I need to find the mean of this data in terms of its streak, but fathom is not giving me an answer cause my table is all representative, here is my data:

0=40

1=26

2=5

3=6

4=1

5=0

6=0

7=0

8=0

9+=0

For some reason I am just hitting a mental block at trying to find this...

the answer should be between 1 and 2, but I cant see how to do this.

thanks for your help :)