| Any cells containing text, logical values and errors are **NOT INCLUDED**. See Examples 7, 8 and 15. |

| The "database" can be a cell reference or a named range. |

| The "database" range of cells must contain column headings in the first row. See Example 19. |

| The "field" can be a column label, a column number (left to right) or a cell reference. |

| The "field" label is not case sensitive. See Example 12. |

| If "field" is left blank, then #VALUE! is returned. See Example 20. |

| If the "field" column contains some text entries, then these are ignored. See Example 7. |

| The "criteria" must include at least one column heading and one cell below the column heading. See Example 16. |

| If "criteria" is left blank, then #VALUE! is returned. See Example 21. |

| The "criteria" must be in a contiguous block of adjacent cells. |

| The "criteria" can be anywhere on the active sheet, although it is recommended not to put it below the data, in case more data is added later on. |

| Make sure the "criteria" and "database" ranges do not overlap and that they are always separated by at least one blank row or column. |

| To perform an operation on an entire column in a database, enter a blank cell below the column heading in the "criteria" range. See Example 11. |

| If no rows match the criteria, then 0 is returned. See Example 14. |

| Example 1 - What is the smallest "Age" for all the people with the name "John" using a field label. |

| Example 2 - What is the smallest "Age" for all the people with the name "John" using a field number. |

| Example 3 - What is the smallest "Salary" for all the people with either the name "John" or the name "James". |

| Example 4 - What is the smallest "Age" for all the people who are less than 22 years old. |

| Example 5 - What is the smallest "Age" for all the people who are less than 22 years old or more than 18 years old. |

| Example 6 - What is the smallest "Salary" for all the people who are less than 22 years old and earn more than £20,000. |

| Example 7 - What is the smallest "Age" for all the people who earn more than £20,000. |

| Example 8 - What is the smallest "Salary" for all the people who earn more than £20,000. |

| Example 9 - What is the smallest "Salary" for all the people with the name "James" who are older than 18 years old. |

| Example 10 - What is the smallest "Salary" for all the people with either the name "James", who are less than 22 years old who earn more than £20,000 or have the name "James" and are older than 18 years old. |

| Example 11 - What is the smallest "Salary" for all the people. Putting a blank cell below the column heading will refer to the entire column. |

| Example 12 - This is the same as Example 11 but with the field label in uppercase. |

| Example 13 - If the "criteria" refers to a range of empty cells, then the entire column from the "database" range is used. |

| Example 14 - If the "criteria" you specify does not return any rows, then 0 is returned. |

| Example 15 - If the "field" you are trying to count is not numeric in this case "Name", then 0 is returned because any text entries are ignored. |

| Example 16 - If the "criteria" only includes a column heading, then #VALUE! is returned. |

| Example 17 - If the "database" range only includes column headings, then #VALUE! is returned. |

| Example 18 - If the "criteria" refers to a single empty cell, then #VALUE! is returned. |

| Example 19 - If the "database" range does not include column headings, then #VALUE! is returned. |

| Example 20 - If "field" is left blank, then #VALUE! is returned. |

| Example 21 - If "criteria" is left blank, then #VALUE! is returned. |

| Example 22 - If "field" does not match one of the column headings, then #VALUE! is returned. |

| For more examples of how to specify your database criteria, please refer to the __Database > Specifying Database Criteria__ page. |

| It is possible to use the data from a pivot table. When the "database" range refers to a cell inside a pivot table, the calculation is only performed on the data currently displayed in the pivot table. |