Examples of using Is the data range in English and their translations into Dutch
{-}
- 
                        Colloquial
                    
- 
                        Official
                    
- 
                        Ecclesiastic
                    
- 
                        Medicine
                    
- 
                        Financial
                    
- 
                        Computer
                    
- 
                        Ecclesiastic
                    
- 
                        Official/political
                    
- 
                        Programming
                    
A1:B12 is the data range that you want to sum,
A2:A15 is the data range that you want to apply the  calculation,
A: F is the data range that you want to sort,
B2:B19 is the data range that you want to count the  question marks,
A1:E7 is the data range that you want to monitor if cell changes,
A2:A15 is the data range that you want to count,
F2 is the data range which contains the  largest value you want to find.
A2:B is the data range that you want to sort,
A2:A27 is the data range you need to sum up.
A2:A16 is the data range contains the  criteria that you based on,“Office Tab” is the  criteria that you use,
A2:A6 is the data range which you add the  values based on,*KTE* stands for the  criteria you need, and B2:B6 is the 
A1:A10 is the data range, and AAA-1 is the  value you want to count,
A2:C7 is the data range, Orange is the  value you want to lookup,
A2:B6 is the data range of the  original data, 
C6:C19)(C6:C19 is the data range which is  filtered you want to count from), and then press Enter key.
Tip: In the  formula, B15 is the  value you want to sum based on, and A1:M12 is the data range, 2,3…12 is the  rows you want to sum up,
type formula=Max(A1:D5)(A1:D5 is the data range you use, and you can use=Min(A1:D5)to find the  minimum value)
C6:C19)(C6:C19 is the data range which is  filtered you want to sum), and then press Enter key.
F2 is the  lookup value you want to return the  whole row based on, A1:D12 is the data range you want to use,
A2:A11 is the data range that you want to know the  largest value,