Documentation/Calc Functions/DMIDDEL
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Template:Documentation/Calc Functions/Func Page Links/da
DMIDDEL
Kategori:
Database
Resume:
Template:DatabaseFunctions-CommonSummaryText/da
DMIDDEL calculates the average of the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria. Non-numeric values in those cells are ignored.
Syntaks:
DMIDDEL(Database; DatabaseField; SearchCriteria)
Returnerer:
Returns a real number that is the average of the extracted numeric values.
Returns a #DIV/0! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records.
Argumenter:
Template:ArgumentsDatabaseFunction/da
Yderligere oplysninger:
Template:AdditionalDetailsDatabaseFunction/da
Eksempler:
Template:ExampleDatabaseFunction/da
The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain ">0" (this search criterion is intended to match all records in the database table).
Template:Calc-Formula/da | Template:Calc-Description/da | Template:Calc-Returns/da |
---|---|---|
=DMIDDEL(A1:E10; "Distance to School"; A12:E13) | Enter this formula into an empty cell elsewhere in the sheet to calculate the average distance in meters travelled to school by Joe’s party guests. | 666,666666666667 |
Many more examples of both search criteria and function calls can be found in this Calc spreadsheet.
Beslægtede LibreOffice-funktioner:
ODF standard:
Tilsvarende Excel-funktioner:
DMIDDEL