How to Use Excel DVAR Function in Office 365? – {with Examples}
Tags: exceldvarfunctionino, excelfunctions
Published: 2020-09-25 03:45:59

---
title: How to Use Excel DVAR Function in Office 365? – {with Examples}
published: true
date: 2020-09-24 11:59:16 UTC
tags: ExcelDVARFunctioninO,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-dvar-function-in-office-365-with-examples/
---

## Excel DVAR Function:

![DVAR Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/DVAR-Function.png)<figcaption id="caption-attachment-14607">DVAR Function</figcaption>

In this article, we are going to explore how to use the **Excel DVAR Function**  **in Office 365** with its syntax, explanation, and example. Let’s get started!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **DVAR Function – Explanation:**

- This function **returns the variance of a sample taken from the list or database based on the given condition or criteria**.

## Syntax:

**=DVAR(database, field, criteria)**

### Arguments Description:

**Database – ** It is the database range including headers.

**Field – ** It is an optional one. This is the field name or index to count.

**Criteria – ** It is the criteria range including headers.

### Note:

- You need to give the field argument as a name within the **double quotes** ( **” “** ) or a number representing the field index.
- The **database** and **criteria ** range must include the matching table headers.

### Note:

- If you didn’t give the field argument as a name within the  **double quotes** ( **” “** ), then it returns **[#NAME? Error](https://geekexcel.com/how-to-fix-name-error-in-excel-office-365-with-example/)**.

## Examples:

Let’s see some examples to make you understand this concept easily.

### Example 1:

- In the below screenshot, you can see the **database**  **range** ( **A4:D11** ) and the  **criteria range ** ( **A1:D2** ).
- The given condition is “ **Product=Pencil, Qty>3** ” and the output is displayed in the **Cell F5.**

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-101.png)<figcaption id="caption-attachment-14606">Example 1</figcaption>

### Example 2:

- If you didn’t give the field argument as a name within the  **double quotes** ( **” “** ), then it returns **[#NAME? Error](https://geekexcel.com/how-to-fix-name-error-in-excel-office-365-with-example/)**.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_iAmWrZlsTC.png)<figcaption id="caption-attachment-14603">Example 2</figcaption>

### Multi-row Criteria

- Multi-row criteria have one or more rows below the headers. These are joined by using [**OR**](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/) logic.
- The expressions in a given criteria row are joined with [**AND**](https://geekexcel.com/how-to-use-and-function-in-microsoft-excel-365/) logic.

## Sum-Up:

In this article, you can clearly understand the usage of **Excel DVAR Function**  **in Office 365** with its syntax, explanation, and example. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Function:

- **DVARP Function**

### Read Ahead:

- [How to Use Excel MEDIAN Function in Office 365? – {with examples}](https://geekexcel.com/how-to-use-excel-median-function-in-office-365-with-examples/)
- [How to Use Excel SHEET Function in Office 365? – {With Examples}](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/)