B
C
D
E
F
G
H
I
J
K
L
M
N
O
2
3
4
5
Show Formula:
6
7
8
CountIf and CountA Function
9
10
Respondents id
Rating Scale
11
Q1 How much did you like or dislike this product overall?
Dislike very much
12
Q2 How likely or unlikely you are to recommend this product?
Dislike Slightly
13
Q3 Ho much did you like or dislike the taste of this product?
Neither like nor dislike
14
Q4 Ho much did you like or dislike the flavour?
Like slightly
15
Q5 Ho much did you like or dislike smell?
Like very much
16
17
% of respondents saying
1
2
3
4
5
18
Q1 How much did you like or dislike this product overall?
19
Q2 How likely or unlikely you are to recommend this product?
20
Q3 Ho much did you like or dislike the taste of this product?
21
Q4 Ho much did you like or dislike the flavour?
22
Q5 Ho much did you like or dislike smell?
23
24
25
26
Countif Counts the number of cells within a range that meet the given criteria.
27
CountA counts the number of cells that are not empty and the values within the list of arguments.
28
29
Change the rating at E17 and see the % change.
30
31
32
This example is contributed by www.xlmacros.com.
33
34
Copyright.
Anthony's VBA Page.
35
36
37
38
39
40
41
42
43
44
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.