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   
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