AVERAGEIFS conditional mean worked example
Learn conditional averaging by computing unit price per order and using AVERAGEIFS to average order amounts for one selected category.
2 tabs · 187 formulas
Topic hub
Pick XLSX to keep formulas and formatting, ODS if you work in LibreOffice, and CSV when a program will read the data. The table compares what each format keeps and how large the same workbook becomes. Below it: public datasets with their sources, plus guides and answers on opening, converting and citing them.
| Format | What it keeps | Median size vs XLSX | Opens in |
|---|---|---|---|
| XLSX | Formulas, formatting, all tabs | 1.0× (median 15.6 KB) | Excel, Google Sheets, LibreOffice Calc, Numbers |
| ODS | Formulas, formatting, all tabs | 0.77× | LibreOffice Calc natively; Excel and Google Sheets open it |
| CSV | Values only; one file per tab, zipped | 0.26× | Any text editor, database or script |
| XML (Excel 2003) | Formulas and formatting, all tabs; no tab colours | 5.7× | Excel and older tools; one plain-text file |
| Numbers | Values only, all tabs | 6.7× | Numbers on Mac, iPad and iPhone |
Sizes: median over 54 workbooks, written by Sheet Reserve’s own browser writers and measured 9 Oct 2026. How the benchmark was run.
Change the inputs in a worked example and follow the calculations. All formula examples.
Learn conditional averaging by computing unit price per order and using AVERAGEIFS to average order amounts for one selected category.
2 tabs · 187 formulas
Learn amount and percentage variance formulas for an expense budget, with explicit treatment of a zero budget.
2 tabs · 186 formulas
Learn how to count records that satisfy both an owner criterion and an open-status criterion.
2 tabs · 127 formulas
Learn calendar-date subtraction and completion-aware overdue formulas using a fixed review date.
2 tabs · 186 formulas
Learn exact-match lookup by retrieving a price from a small product table using a selected SKU.
2 tabs · 127 formulas
Learn how to clamp raw observations between lower and upper bounds and normalize them onto a zero-to-one hundred percent scale.
2 tabs · 247 formulas
Learn conditional summation by calculating order amounts and a sales total for one selected region.
2 tabs · 127 formulas
Learn TRIM, UPPER, LOWER, and LEN by preparing names and reference codes while preserving the original text.
2 tabs · 306 formulas
Learn exact VLOOKUP by retrieving a department allowance from a keyed table with missing and duplicate-key checks.
2 tabs · 127 formulas
Learn weighted averages by calculating each observation’s value times its weight and dividing the total by total weight.
2 tabs · 127 formulas
Total and per capita CO2 emissions, renewable energy share and electricity access for 217 economies, 2000-2024.
8 tabs · 1,757 formulas
Safely managed and basic drinking water, sanitation and handwashing shares for 217 economies, 2000-2024, from the World Bank.
9 tabs · 3,157 formulas
Forest cover (% and sq. km), agricultural land share and arable land share for 217 economies, 2000-2024.
8 tabs · 1,757 formulas
Freshwater withdrawals by sector, renewable resources and water stress for 186 countries, from the World Bank and FAO AQUASTAT.
5 tabs · 1,348 formulas
GDP, GDP per capita and growth for 217 countries and territories, 1990-2025, from the World Bank.
7 tabs · 889 formulas
Monthly, annual, hemispheric and zonal global temperature anomalies from NASA GISTEMP, 1880-2025, with warming stripes.
7 tabs · 1,132 formulas
Consumer price and GDP deflator inflation for 217 economies, 1990-2025, from the World Bank, with decade averages and latest-year rankings.
7 tabs · 4,099 formulas
Temperature, precipitation, humidity, wind and solar radiation for 60 cities, month by month, from NASA POWER.
5 tabs · 1,048 formulas
Merchandise and services trade, exports, imports and current account balance (% of GDP) for 217 economies, 2000-2025.
8 tabs · 1,757 formulas
Urban and rural shares of population with at least basic drinking water and sanitation across 217 economies, 2000-2024.
8 tabs · 1,989 formulas
7,342 populated places with coordinates, Natural Earth population estimates, capitals and World Bank regions.
6 tabs · 31,490 formulas
217 countries and territories with ISO codes, capitals, area, population, region and income level.
4 tabs · 581 formulas
Every dataset keeps its original units and names its source and licence. See Data sources and licences.
15 tools to convert, inspect, and prepare data on your own device, with nothing uploaded.