Pocket Excel: "#VALUE" Error Value When Querying Database

RESOLUTION

To work around this problem, use the appropriate method for the Pocket Excel function you want to use.

Dcount Function

To work around this problem when you use the Dcount function, use an equation similar to the following sample

   =dcount(<database>,<field>,<criteria>)
				

where <database> is the range of cells that make up the list or database, <field> is the number of a column in the database that contains numeric data, and <criteria> is the range of cells that contains the conditions you specify.

NOTE: The Dcount function does not count a row in which the cell in the selected column does not contain numeric data, even if the row otherwise matches the search criteria.

Dcounta Function

To work around this problem when you use the Dcounta function, use an equation similar to the following sample

   =dcounta(<database>,<field>,<criteria>)
				

where <database> is the range of cells that make up the list or database, <field> is the number of a column in the database, and <criteria> is the range of cells that contains the conditions you specify.

NOTE: The Dcounta function does not count a row in which the cell in the selected column is empty, even if the row otherwise matches the search criteria.