Excel library
Excel Formulas to Count and Sum
Counting and summing formulas answer the most common spreadsheet questions: how many, and how much. COUNTIF and SUMIF handle a single condition; COUNTIFS and SUMIFS take several, such as a region and a date range together.
Unique and duplicate values need a different approach. In Microsoft 365, UNIQUE and FILTER do most of the work; in older versions, SUMPRODUCT and COUNTIF combinations do the same job.
The tutorials below cover conditional counts and sums, unique values, duplicates across columns, counting text and characters, and totals across several sheets.
Start here
Master Excel COUNTIF Formula: Examples, Syntax & Tips!
Master the Excel COUNTIF formula with this comprehensive guide. Learn how to count cells based on conditions using examples, syntax, and advanced techniques.
How to Use SUMIF with Multiple Criteria in an Excel Formula?
Learn how to use SUMIF with multiple criteria in Excel. Sum values based on two or more conditions using SUMIF or SUMIFS functions. Tips & examples included.
Excel Formula to Count Unique Values
Count distinct values in Excel with COUNTA(UNIQUE()) or SUMPRODUCT(1/COUNTIF()), ignore blanks, add conditions, or use a pivot table's Distinct Count.
How to Find Duplicate Values in Excel Using Formula?
Find and remove duplicate values in Excel using COUNTIF, COUNTIFS, and conditional formatting. Learn advanced techniques for efficient data cleaning.
More in Count & sum
- Count Between Two Numbers in Excel using Simple Formula!
- Easy Excel Formula to Count Across Multiple Sheets
- How to Find Same Values in Two Columns in Excel Using a Formula?
- How to Use SUMIFS Across Multiple Columns in Excel?
- How to Count Cells with Text in Excel Using Formulas?
- How to Find the Most Frequent Text with Criteria Using Excel Formula?
- Simple & Easy Excel Formula to Sum with Filters
- How to Create a List Without Duplicates Using an Excel Formula?
- How to Use the Formula for Frequency in Excel: A Comprehensive Guide
- Combining Two Lists Without Duplicates in Excel: A Formula Guide
- Excel Guide: Listing Unique Values Excluding Blanks with Formula
- How to Use Excel Formulas on Visible Cells Only?
- How to Use Excel Formula to Sum Without Duplicates?
- Easy Excel Formula to Sum YTD Based on Month