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 Duplicates Once (First Occurrences Only)
Learn the Excel formula to count duplicates with first occurrences only and easily count unique items that appear multiple times in your spreadsheet.
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.
How to Count Merged Cells with Content in Excel
Learn how to use a simple Excel formula to quickly count only the merged cells that contain data or text.
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.
Excel Formula to Count Specific Characters Using the SUBSTITUTE Function
Learn how to easily count specific characters in Excel using a simple formula combining the LEN and SUBSTITUTE functions with step-by-step examples.
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 Greater Than Zero in Excel Using COUNTIF
Learn how to quickly count numbers greater than zero in Excel using the simple COUNTIF formula in this easy, step-by-step guide.
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.
Excel Formulas to Count Specific Characters in a Text String
Learn how to count specific characters in an Excel cell or string using a simple formula combining the LEN and SUBSTITUTE functions.
Excel Formula to Count Cells by Background Color
Learn how to count cells by background color in Excel using simple VBA code, GET.CELL, or the Filter tool in this 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 Formula to Count Filtered and Visible Rows in a Table
Learn how to easily count only visible, filtered rows in an Excel table using the SUBTOTAL formula in this quick, step-by-step guide.
How to Count Non-Empty Cells Excluding Formulas in Excel
Learn how to count non-empty cells in Excel excluding formulas using a simple combination of SUMPRODUCT and ISFORMULA to count only hardcoded data.
How to Count Unique Values in a Filtered Range in Excel
Learn how to count distinct values in a filtered Excel range using a combination of SUMPRODUCT and SUBTOTAL to count only visible unique data.
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.