Excel TipsFormulasData Analysis
How to Use SUM, AVERAGE, and COUNT in Excel
Learn how to use SUM, AVERAGE, and COUNT in Excel to add numbers, calculate averages, and count entries, with syntax and examples.
·4 min read
All Guides
Excel Math and Statistical Functions
Summarize and analyze numbers with SUM, COUNT, AVERAGE, the conditional IFS family, rounding, and statistical functions.
16 guides in this collection
Excel TipsFormulasData Analysis
COUNTIF and SUMIF in Excel: Complete Guide with Examples
Learn how to use Excel's COUNTIF and SUMIF functions to perform conditional counting and summation. This guide includes syntax, examples, and use cases.
·3 min read
Excel TipsFormulasData Analysis
How to Use SUMIFS in Excel (With Examples)
Learn how to use the SUMIFS function in Excel to sum values based on multiple conditions. This guide includes syntax and a step-by-step example.
·3 min read
Excel TipsFormulasData Analysis
How to Use COUNTIFS in Excel (With Examples)
Learn how to use COUNTIFS in Excel to count cells that meet multiple conditions, with syntax, examples, and comparison to COUNTIF.
·3 min read
Excel TipsFormulasData Analysis
How to Use AVERAGEIF and AVERAGEIFS in Excel
Learn how to use AVERAGEIF and AVERAGEIFS to calculate conditional averages in Excel, with syntax, examples, and comparison tables.
·6 min read
Excel TipsFormulasData Analysis
How to Use MAXIFS and MINIFS in Excel
Learn how to use MAXIFS and MINIFS to find the largest and smallest values that meet one or more conditions in Excel.
·5 min read
Excel TipsFormulasData Analysis
How to Use MIN and MAX in Excel
Learn how to use MIN and MAX to find the smallest and largest values in a range, spot extremes in your data, and measure the spread.
·3 min read
Excel TipsFormulas
How to Use COUNTA and COUNTBLANK in Excel
Learn how to count non-empty and empty cells when your data has text, dates, or a mix of types that COUNT skips.
·4 min read
Excel TipsFormulasData Analysis
How to Use SUMPRODUCT in Excel
Learn how to use SUMPRODUCT for total revenue calculations, conditional counting, conditional summing, and weighted averages in Excel.
·5 min read
Excel TipsFormulasData Analysis
How to Calculate Percentages in Excel
Learn how to calculate percentage of total, percentage change, markup, and discount in Excel, plus how to avoid the most common formatting mistake.
·5 min read
Excel TipsFormulas
How to Use ROUND, ROUNDUP, and ROUNDDOWN in Excel
Learn how to use ROUND, ROUNDUP, and ROUNDDOWN to control decimal places in Excel, with practical examples for reports and budgets.
·4 min read
Excel TipsFormulas
How to Use CEILING, FLOOR, and MROUND in Excel
Learn how to use CEILING, FLOOR, and MROUND to round values to specific multiples like quarter hours, $5 increments, or container quantities.
·4 min read
Excel TipsFormulas
How to Use ABS, INT, and MOD in Excel
Learn how to use ABS for direction-free differences, INT for whole-number results, and MOD for remainders after division.
·5 min read
Excel TipsFormulasData Analysis
How to Use MEDIAN, PERCENTILE, and QUARTILE in Excel
Learn how to use MEDIAN, PERCENTILE, and QUARTILE to summarize data more accurately than AVERAGE, especially when outliers are present.
·5 min read
Excel TipsFormulasData Analysis
How to Use STDEV and VAR in Excel
Learn how to use STDEV and VAR to measure how spread out your data is, even when AVERAGE makes two very different datasets look the same.
·4 min read
Excel TipsFormulasData Analysis
How to Use LARGE, SMALL, and RANK in Excel
Learn how to use LARGE, SMALL, and RANK to find the nth highest or lowest value and rank entries in a list in Excel.
·4 min read