Excel Formulas - Count Category
Master the COUNT formula in Excel to accurately track numeric data. Learn how to use COUNT, COUNTA, and COUNTIF functions with clear examples to streamline your data analysis and reporting.
How to Count Cells with Specific Text in Excel
Learn how to use the Excel COUNTIF formula to count cells with specific text, including exact and partial matches, with quick step-by-step examples.
Excel COUNTIFS Formula: Counting Numbers with Multiple Conditions
Learn how to use the Excel COUNTIFS formula to count numbers based on multiple conditions or criteria with easy, step-by-step examples.
How to Count Unique Values with Criteria in Excel
Learn how to count unique values in Excel with criteria using easy formulas like UNIQUE, FILTER, and SUMPRODUCT in this step-by-step guide.
Excel Formula to Count Dates Excluding Weekends
Learn how to use Excel's NETWORKDAYS formula to easily count the number of days between two dates while excluding weekends and holidays.
Excel Formula to Count Case-Sensitive Exact Word Matches
Learn how to count exact, case-sensitive word matches in Excel using a powerful formula combination of SUMPRODUCT and EXACT.
Excel Formula to Count Wildcard Matches Using the Question Mark
Learn how to use the Excel COUNTIF formula to count literal question marks (?) by escaping the wildcard character with a tilde (~).
Excel LEN Function: How to Count Character and Text Length
Learn how to use the Excel LEN function to quickly count text length, characters, and spaces in your spreadsheets with easy, step-by-step examples.
Excel Formula to Count Empty Spaces Using TRIM and LEN
Learn how to use an Excel formula with the TRIM and LEN functions to accurately count spaces and clean up unwanted padding in your text cells.
Excel Formula to Count Values Exceeding Dynamic Thresholds
Learn how to use Excel formulas like COUNTIF to easily count values that exceed dynamic, cell-referenced thresholds for smarter data analysis.
Counting Alternating Rows in Excel Using the MOD Function
Learn how to count alternating (every other) rows in Excel using a simple formula combining the MOD and ROW functions.
Excel Formula to Count Substring Occurrences Using the SEARCH Function
Learn how to count substring occurrences in Excel using a case-insensitive formula combining the SEARCH and LEN functions.
How to Count Cells with Multiple Criteria in Excel
Learn how to use the COUNTIFS formula in Excel to quickly count cells that meet multiple criteria with easy, step-by-step examples.
How to Count Unique Values in Excel Using Formulas
Learn how to count unique values in an Excel range using simple formulas like UNIQUE, COUNTA, or SUMPRODUCT. Master your Excel data analysis today!
Excel Word Count Formula: Step-by-Step Guide to Counting Words in a Cell
Learn the simple Excel formula to count words in a single cell using LEN and SUBSTITUTE with this quick, step-by-step guide.
How to Count Dates by Month in Excel
Learn how to easily count dates in a specific month in Excel using formulas like COUNTIFS and SUMPRODUCT with this quick step-by-step guide.
Excel Formulas to Count Rows with Error Values
Learn how to quickly count rows containing error values in Excel using a simple formula with the SUMPRODUCT and ISERROR functions.
Excel Formulas to Count Even Numbers in a Dataset
Learn how to easily count even numbers in Excel using a simple formula combining SUMPRODUCT and MOD. Master this quick dataset tip today!
Excel Formulas to Count Rows Matching Multiple OR Criteria
Learn how to count rows in Excel that meet any of multiple criteria using powerful formulas like SUMPRODUCT and COUNTIF with OR logic.
How to Count Cells with Bold Formatting in Excel
Discover how to count cells with bold text in Excel using a custom VBA formula and the GET.CELL method. Quick, step-by-step tutorial with examples!
How to Count Consecutive Days of Attendance in Excel
Learn how to use Excel formulas to count consecutive days of attendance and easily track employee or student streaks with this step-by-step guide.
How to Count Unique Values Based on Another Column in Excel
Learn how to count unique values based on criteria in another column using Excel formulas like UNIQUE, FILTER, and SUMPRODUCT. Step-by-step guide.
Excel Formulas to Count Cells While Ignoring Errors
Learn how to count cells in Excel while ignoring formula errors using the AGGREGATE, COUNTIF, or SUMPRODUCT functions for accurate data analysis.
Excel Formula to Count Cells with Specific Text Length
Learn how to count rows with a specific text length in Excel using a simple formula combining the SUMPRODUCT and LEN functions.
How to Count Leap Years Between Two Dates in Excel
Learn how to write an Excel formula to count leap years between two dates. Step-by-step guide to accurately calculate leap years in any date range.
Excel Formulas to Count Numbers Stored as Text
Discover the Excel formula to count numbers expressed as text using SUMPRODUCT and VALUE to easily clean and fix your spreadsheet data.