Documentation/Calc Functions/DMIDDEL

From The Document Foundation Wiki
Jump to navigation Jump to search
This page is a translated version of the page Documentation/Calc Functions/DAVERAGE and the translation is 11% complete.
Outdated translations are marked like this.
Other languages:
English • ‎Nederlands • ‎dansk

Template:Documentation/Calc Functions/Func Page Links/da

Funktionsnavn:

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:

MIDDEL

DTÆL

DTÆLV

DHENT

DMAKS

DMIN

DPRODUKT

DSTDAFV

DSTDAFVP

DSUM

DVARIANS

DVARIANSP

ODF standard:

Tilsvarende Excel-funktioner:

DMIDDEL