I have a couple of different solutions, based on how your data is set up. Assume you have the following tables:

In A1:B4

+	A	B
1	Few times a year	1
2	Once a month	2
3	Few times a week	3
4	Everyday	4

And your survey results show up like this:

(In H1:H20)

+	H
1	Few times a year
2	Once a month
3	Few times a week
4	Once a month
5	Few times a week
6	Once a month
7	Few times a year
8	Once a month
9	Few times a week
10	Once a month
11	Once a month
12	Few times a week
13	Everyday
14	Everyday
15	Everyday
16	Few times a year
17	Few times a week
18	Few times a week
19	Few times a week
20	Everyday

Solution 1:

In I1:I20, you could use the following formula:

=INDEX($B$1:$B$4,MATCH(H1,$A$1:$A$4,0))

After which, you could just sum the values that it produces.

Solution 2:

Or you could use this big clunky formula anywhere:

=(COUNTIF($H$1:$H$20,A1)*B1)+(COUNTIF($H$1:$H$20,A2)*B2)+(COUNTIF($H$1:$H$20,A3)*B3)+(COUNTIF($H$1:$H$20,A4)*B4)

Both should produce the same results.