---
title: "AVERAGEIF and AVERAGEIFS practice exercises | PracticeExcel"
description: "Practice AVERAGEIF and AVERAGEIFS in a live spreadsheet, with one condition, two conditions and averages that skip zeros."
canonical_url: "https://practiceexcelonline.com/practice/averageif"
locale: en
meta:
  "og:description": "Practice AVERAGEIF and AVERAGEIFS in a live spreadsheet, with one condition, two conditions and averages that skip zeros."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_AVERAGEIF%2Band%2BAVERAGEIFS%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgQVZFUkFHRUlGIGFuZCBBVkVSQUdFSUZTIGluIGEgbGl2ZSBzcHJlYWRzaGVldCwgd2l0aCBvbmUgY29uZGl0aW9uLCB0d28gY29uZGl0aW9ucyBhbmQgYXZlcmFnZXMgdGhhdCBza2lwIHplcm9zLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIkNoYW5uZWwiLCJPcmRlciB2YWx1ZSIsIkF2ZXJhZ2Ugb25saW5lIl19LHsibiI6MiwiY2VsbHMiOlsiT25saW5lIiwiNDIwIiwiIl19LHsibiI6MywiY2VsbHMiOlsiU3RvcmUiLCIzMTAiLCIiXX0seyJuIjo0LCJjZWxscyI6WyJPbmxpbmUiLCI1ODAiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJTdG9yZSIsIjI3MCIsIiJdfSx7Im4iOjYsImNlbGxzIjpbIk9ubGluZSIsIjM1MCIsIiJdfV0sInRhcmdldCI6WzEsMl19fQ%2Cp_Ii9wcmFjdGljZS9hdmVyYWdlaWYi%2Cs_U8WyUyR69ucaKc0W.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "AVERAGEIF and AVERAGEIFS practice exercises | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_AVERAGEIF%2Band%2BAVERAGEIFS%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgQVZFUkFHRUlGIGFuZCBBVkVSQUdFSUZTIGluIGEgbGl2ZSBzcHJlYWRzaGVldCwgd2l0aCBvbmUgY29uZGl0aW9uLCB0d28gY29uZGl0aW9ucyBhbmQgYXZlcmFnZXMgdGhhdCBza2lwIHplcm9zLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIkNoYW5uZWwiLCJPcmRlciB2YWx1ZSIsIkF2ZXJhZ2Ugb25saW5lIl19LHsibiI6MiwiY2VsbHMiOlsiT25saW5lIiwiNDIwIiwiIl19LHsibiI6MywiY2VsbHMiOlsiU3RvcmUiLCIzMTAiLCIiXX0seyJuIjo0LCJjZWxscyI6WyJPbmxpbmUiLCI1ODAiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJTdG9yZSIsIjI3MCIsIiJdfSx7Im4iOjYsImNlbGxzIjpbIk9ubGluZSIsIjM1MCIsIiJdfV0sInRhcmdldCI6WzEsMl19fQ%2Cp_Ii9wcmFjdGljZS9hdmVyYWdlaWYi%2Cs_U8WyUyR69ucaKc0W.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)

# **AVERAGEIF and AVERAGEIFS practice exercises**

Take the average of only the rows that meet one condition, or several with AVERAGEIFS, and leave zeros out of an average.

[**Start the first exercise**](https://practiceexcelonline.com/practice/averageif/averageif)

AVERAGEIF(AVERAGEIFS(

1. [**1****Average one group with AVERAGEIF**In D2, use AVERAGEIF to find the average order value of the Online orders.](https://practiceexcelonline.com/practice/averageif/averageif)
2. [**2****Average with two conditions with AVERAGEIFS****Premium**In F1, find the average sale of Shoes in the North region. AVERAGEIFS starts with the range to average, then each range with its condition.](https://practiceexcelonline.com/practice/averageif/averageifs-two-conditions)
3. [**3****Leave zeros out of an average****Premium**The store is closed on Mondays and Sundays and records 0 sales. In E1, find the average sales of the days it was open: AVERAGEIF with the condition ">0".](https://practiceexcelonline.com/practice/averageif/average-without-zeros)

## **Functions in this topic**

- [**AVERAGEIF**](https://practiceexcelonline.com/functions/averageif)
- [**AVERAGEIFS**](https://practiceexcelonline.com/functions/averageifs)

## **Read the guide**

- [**Pivot tables explained, and the formulas that do the same job**](https://practiceexcelonline.com/learn/pivot-tables)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/practice/averageif#webpage","description":"Practice AVERAGEIF and AVERAGEIFS in a live spreadsheet, with one condition, two conditions and averages that skip zeros.","name":"AVERAGEIF and AVERAGEIFS practice exercises","url":"https://practiceexcelonline.com/practice/averageif","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/averageif#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/averageif"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/averageif#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"AVERAGEIF and AVERAGEIFS practice exercises","position":3}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.