How to Use Excel DVARP Function in Office 365? – {with Examples}
Tags: exceldvarpfunctionin, excelfunctions
Published: 2020-09-28 08:00:43

---
title: How to Use Excel DVARP Function in Office 365? – {with Examples}
published: true
date: 2020-09-28 06:49:09 UTC
tags: ExcelDVARPFunctionin,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-dvarp-function-in-office-365-with-examples/
---

## Excel DVARP Function:

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

In this article, you will learn how to use **Excel DVARP Function**  **in Office 365** with its syntax, explanation, and example. 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)
## **DVARP Function – Definition:**

- This function **returns the variance of the entire population by using the values in a list or database**  **based on the given condition or criteria**.

## Syntax:

**=DVARP(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 provide 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:

Here are the examples for your reference.

### 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-102.png)<figcaption id="caption-attachment-14610">Example 1</figcaption>

### Example 2:

- If you didn’t provide 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_LWWUjMXH6s.png)<figcaption id="caption-attachment-14682">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.

## End of the Article:

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

### Similar Function:

- **DVAR Function**

### Keep Reading:

- [How to Use Excel LCM Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-lcm-function-in-office-365-with-examples/)
- [How to Use Excel ATAN2 Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-atan2-function-in-office-365-with-examples/)