### Database Functions

Before there were __Tables__ data that was organised in rows and columns was referred to as a __Database__.

A database in Excel can be any size and should contain unique column headings to identify the different fields.

There are 12 specific worksheet functions dedicated to working with tables of data.

They all begin with the letter "D" and are often referred to as the Dfunctions.

DAVERAGE | The arithmetic mean of non blank cells in a database column satisfying certain conditions. |

DCOUNT | The total number of non blank cells in a database column satisfying certain conditions. |

DCOUNTA | The total number of non blank cells in a database column satisfying certain conditions (including logical values and text). |

DGET | The single value in a database column satisfying certain conditions. |

DMAX | The maximum value in a database column satisfying certain conditions. |

DMIN | The minimum value in a database column satisfying certain conditions. |

DPRODUCT | The product of values in a database column satisfying certain conditions. |

DSTDEV | The standard deviation of a database column satisfying certain conditions based on a sample. |

DSTDEVP | The standard deviation of a database column satisfying certain conditions based on an entire population. |

DSUM | The sum of values in a database column satisfying certain conditions. |

DVAR | The variance of a database column satisfying certain conditions based on a sample. |

DVARP | The variance of a database column satisfying certain conditions based on an entire population. |

DAVERAGEThe arithmetic mean of non blank cells in a database column satisfying certain conditions. |

DCOUNTThe total number of non blank cells in a database column satisfying certain conditions. |

DCOUNTAThe total number of non blank cells in a database column satisfying certain conditions (including logical values and text). |

DGETThe single value in a database column satisfying certain conditions. |

DMAXThe maximum value in a database column satisfying certain conditions. |

DMINThe minimum value in a database column satisfying certain conditions. |

DPRODUCTThe product of values in a database column satisfying certain conditions. |

DSTDEVThe standard deviation of a database column satisfying certain conditions based on a sample. |

DSTDEVPThe standard deviation of a database column satisfying certain conditions based on an entire population. |

DSUMThe sum of values in a database column satisfying certain conditions. |

DVARThe variance of a database column satisfying certain conditions based on a sample. |

DVARPThe variance of a database column satisfying certain conditions based on an entire population. |

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext