How do i count rating answers from a number of respondents.. Please help

[syeve9186]

Please help me.. Im having a research now and i want to count the answers of my respondents in each row/category.. I want to know how to count the number of respondents that answered 1, 2, 3, 4, 5 (rate) in the first question... Please take a loot at my table.. Please...

 

[Aladin Akyurek]

Please help me.. Im having a research now and i want to count the answers of my respondents in each row/category.. I want to know how to count the number of respondents that answered 1, 2, 3, 4, 5 (rate) in the first question... Please take a loot at my table.. Please...

Try to post a tiny sample illustrative of your data.

 

[T. Valko]

Please help me.. Im having a research now and i want to count the answers of my respondents in each row/category.. I want to know how to count the number of respondents that answered 1, 2, 3, 4, 5 (rate) in the first question... Please take a loot at my table.. Please...

Maybe something like this...

Book1
	A	B	C	D
2	4	_	1	3
3	1	_	2	4
4	2	_	3	3
5	4	_	4	7
6	1	_	5	2
7	2	_	_	_
8	1	_	_	_
9	3	_	_	_
10	4	_	_	_
11	5	_	_	_
12	4	_	_	_
13	2	_	_	_
14	4	_	_	_
15	2	_	_	_
16	5	_	_	_
17	3	_	_	_
18	4	_	_	_
19	4	_	_	_
20	3	_	_	_
Sheet1

Formula entered in D2 and copied down:

=COUNTIF(A$2:A$20,C2)