Database and Inventory management functions for Excel functions

Source: Internet
Author: User
Tags ranges

1. Excel database and Inventory management functions: Daverage

Parameters returns the average of the values in the column in the database or list that meet the criteria you specify.

"Syntax" Daverage (Database,field,criteria)

The parameters database makes up the range of cells in the list or database. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

2. Excel database and Inventory management functions: DCOUNT

Parameters returns the number of cells in a specified field in a database or list that meet a given condition and contain numbers.

"Syntax" DCOUNT (Database,field,criteria)

The parameters database makes up the range of cells in the list or database. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

3. Excel database and Inventory management functions: Dcounta

Parameters returns the number of non-null cells in the specified field in the database or list that meet the given criteria.

"Syntax" Dcounta (Database,field,criteria)

The parameters database makes up the range of cells in the list or database. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

4. Excel database and Inventory management functions: Dget

Parameters extracts a single value from a list or database that matches a specified condition.

"Syntax" Dget (Database,field,criteria)

The parameters database makes up the range of cells in the list or database. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

5. Excel database and Inventory management functions: DMAX

Parameters returns the maximum number in a specified column in a list or database that satisfies a given condition.

"Syntax" DMAX (Database,field,criteria)

The parameters database makes up the range of cells in the list or database. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

6. Excel database and Inventory management functions: DMIN

Parameters returns the smallest number in a cell in a specified column in a list or database that satisfies a given condition.

"Syntax" DMIN (Database,field,criteria)

The parameters database makes up the range of cells in the list or database. FIELD Specifies the data column used by the function. Criteria is a set of ranges of cells that contain the given criteria.

7. Excel database and Inventory management functions: Dproduct

Parameter returns the product of a number in a specified column of a list or database that satisfies a given condition cell.

"Syntax" Dproduct (Database,field,criteria)

"Parameters" ditto

8. Excel database and Inventory management functions: DSTDEV

Parameter estimates the standard deviation of the sample population as a sample of the number of columns in the list or database that meet the criteria you specify.

"Syntax" DSTDEV (Database,field,criteria)

"Parameters" ditto

9. Excel database and Inventory management functions: DSTDEVP

Parameters calculates the overall standard deviation for a population in a specified column of a list or database that satisfies a number in a given condition cell.

"Syntax" DSTDEVP (Database,field,criteria)

"Parameters" ditto

10. Excel database and Inventory management functions: DSUM

Parameters returns the sum of the numbers in a specified column of a list or database that satisfies a given condition cell.

"Grammar" DSUM (Database,field,criteria)

"Parameters" ditto

11. Excel database and Inventory management functions: DVAR

Parameters estimates the variance of the population in a specified column of a list or database as a sample of the number in a given condition cell.

"Syntax" DVAR (Database,field,criteria)

"Parameters" ditto

12. Excel database and Inventory management functions: DVARP

Parameters calculates the overall variance of the population in the list or in the specified column of the database that satisfies the number in the given condition cell as the population.

"Syntax" DVARP (Database,field,criteria)

"Parameters" ditto

13. Excel database and Inventory management functions: GETPIVOTDATA

Parameters returns the data stored in the PivotTable report. If the summary data in the report is visible, you can use function GETPIVOTDATA to retrieve the summarized data from the PivotTable report.

"Syntax" GETPIVOTDATA (pivot_table,name)

The parameter Data_field the name of the data field that contains the data you want to retrieve (enclosed in quotation marks). Pivot_table a reference to any cell, range of cells, or defined range of cells in a PivotTable report that determines which data PivotTable report contains the data to retrieve. Field1,item1, field2,item2 1 to 14 pairs of field names and item names used to describe the retrieved data can be arranged in any order.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.