Syntax
=DVAR(database, field, criteria)Arguments
| Argument | Required | Description |
|---|---|---|
database | Required | The list, with field names in the first row |
field | Required | The field name or column number to use |
criteria | Required | A range with field names in the first row and conditions below |
How to use DVAR
DVAR takes 3 required arguments. Type =DVAR( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=DVAR(A1:E7, "Yield", A1:A2)Result Data in the sheet
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Tree | Height | Age | Yield | Profit | Tree | ||
| 2 | Apple | 18 | 20 | 14 | 105 | Apple | ||
| 3 | Pear | 12 | 12 | 10 | 96 | Pear | ||
| 4 | Cherry | 13 | 14 | 9 | 105 | |||
| 5 | Apple | 14 | 15 | 10 | 75 | |||
| 6 | Pear | 9 | 8 | 8 | 77 | |||
| 7 | Apple | 8 | 9 | 6 | 45 |
Related database functions
- DCOUNTACounts the non empty cells in a field of the records that match the criteria.
- DGETReturns the single value of a field from the one record that matches the criteria.
- DMAXReturns the largest number in a field of the records that match the criteria.
- DMINReturns the smallest number in a field of the records that match the criteria.
- DPRODUCTMultiplies the numbers in a field of the records that match the criteria.
- DSTDEVEstimates the standard deviation of a sample from a field of the records that match the criteria.
- DSTDEVPCalculates the standard deviation of a whole population from a field of the records that match the criteria.
- DSUMAdds the numbers in a field of the records that match the criteria.
- DVARPCalculates the variance of a whole population from a field of the records that match the criteria.