IMTANH DAVERAGE

Database

  • DAVERAGE — average of the values in field in database belonging to records that match criteria
  • DCOUNT — count of numbers in field in database belonging to records that match criteria
  • DCOUNTA — count of cells with data in field in database belonging to records that match criteria
  • DGET — a value from field in database belonging to records that match criteria
  • DMAX — largest number in field in database belonging to a record that match criteria
  • DMIN — smallest number in field in database belonging to a record that match criteria
  • DPRODUCT — product of all values in field in database belonging to records that match criteria
  • DSTDEV — sample standard deviation of the values in field in database belonging to records that match criteria
  • DSTDEVP — standard deviation of the population of values in field in database belonging to records that match criteria
  • DSUM — sum of the values in field in database belonging to records that match criteria
  • DVAR — sample variance of the values in field in database belonging to records that match criteria
  • DVARP — variance of the population of values in field in database belonging to records that match criteria
  • GETPIVOTDATA — summary data from a pivot table
IMTANH DAVERAGE