- You create a table that has two or more columns of data on a worksheet.
- You insert a new PivotTable into the worksheet that is based on the new table's data.
- You enter a formula by using either of the following database functions:
- You use the PivotTable's cell references for the database parameter of the database function. And, you use the cell reference for the column in the PivotTable for the field parameter of the database function.
For example, consider the following scenario. The PivotTable is in cells C10:F20. The targeted column is F10, and this column has the column label of "Total." The database table on which the PivotTable is based is in N1:Q10. The criteria for the function are H2:H12. The DCOUNT function parameters are as follows:
database = C10:F20
field = F10
criteria = H2:H12
The function is written as follows:DCOUNT(C10:F20,F10,H2:H12)
For example, by using the example in the "Symptoms" section, the DCOUNT function can be rewritten as follows: