Excel Tips: Calculation & Formulas > Statistic Functions

COUNT Function

Count characters or words

How to count a character in an Excel cell or a range?

How to count characters in cell/range/worksheet in Excel?

How to count comma separated values in a single cell in Excel?

How to count frequency of a text/number/character in Excel column?

How to count how often a word or a value occurs in Excel?

How to count max or min occurrences in Excel?

How to count number of “Yes” or “No” answer in Excel?

How to count number of certain/specific words in a cell or a range of cells in Excel?

How to count number of lines (line breaks) in a cell in Excel?

How to count number of occurrence in a column in Google sheet?

How to count occurrences of specific character in a cell in Excel?

How to count specific characters (comma/semicolon/question marks) in cell/range in Excel?

How to count the frequency of text values in a column?

How to count the line breaks in cell in Excel?

How to count the number of a word or character in an Excel column or cell?

How to count the number of characters excluding spaces in Excel cell?

How to count the number of characters, letters and numbers in cell?

How to count the number of commas/dashes separated values in a cell in Excel?

How to count the number of occurrences of a word in a column in Excel?

How to count the number of occurrences per year/quarter/month/week in Excel?

How to count the number of spaces before text string in Excel cell?

How to count the number of spaces of text string in Excel?

How to count the number of times a character / word appears in a cell?

How to count the number of times a word / number appears in a range?

How to count the number of uppercase or lowercase letter in cell?

How to count the number of words in a cell or a range cells in Excel?

How to countif wildcards (asterisks or question marks) in Excel?

How to determine frequency of a character/text/string in an Excel range?

Count days between two dates

How to check if a date is public holiday and count days except holidays in Excel?

How to count / calculate quarters between two dates in Excel?

How to count / calculate weeks / months / years between two dates in Excel?

How to count days between two dates including start date in Excel?

How to count number of leap years between two dates in Excel?

How to count the days excluding Sundays between two dates in Excel?

How to count the number of days / workdays / weekends between two dates in Excel?

How to count the number of days except Sunday/weekends in Excel?

How to count the number of days or workdays in a month in Excel?

How to count the number of weekends/weekdays between two dates in Excel?

Count duplicate or unique cells

How to compare two columns and count differences in Excel?

How to count and remove duplicates from a list in Excel?

How to count consecutive duplicates in Excel?

How to count duplicate values in a column in Excel?

How to count duplicates between two columns in Excel?

How to count same or duplicate values only once in a column?

How to count the number of unique rows (combinations of multiple columns) in Excel?

How to count unique values based on another column in Excel?

How to count unique values based on multiple criteria in Excel?

How to count unique values between two dates in Excel?

How to count unique values excluding duplicates in Excel?

How to count unique values in a filtered column in Excel?

How to count unique values in pivot table?

How to count unique values or numbers in a column in Excel?

How to count unique values with blanks in an Excel column?

How to count unique values with multiple criteria in Excel?

How to count unique/duplicate dates in an Excel column?

How to count unique/duplicate dates in an Excel column?

How to find and count duplicate cells/values in a single row in Excel?

How to quickly count the first instance only of values in Excel?

Count ignoring cells

How to count / sum cells based on filter with criteria in Excel?

How to count / sum odd / even numbers or rows in Excel?

How to count / sum only positive or negative numbers in Excel?

How to count all cells with value/data in a range in Excel?

How to count blank cells or nonblank cells in a range in Excel?

How to count blank or non-blank cells in filtered range in Excel?

How to count blank or non-blank cells in filtered range in Excel?

How to count if cells contain any date/data in Excel?

How to count ignore hidden cells/rows/columns in Excel?

How to count ignoring zeros or blank cells in Excel?

How to count number of cells with nonzero values in Excel?

How to count number of continuous blank cells in Excel?

How to count the number of cells with data in Excel?

How to count the number of populated cells in a range in Excel?

How to Countif filtered data/list with criteria in Excel?

How to quickly count visible or filtered cells only in Excel?

Count sheets or workbooks

How to count the number of sheets of a workbook?

How to count the number of visible sheets in a workbook?

How to count worksheets with specific name in Excel?

How to quickly count the number of all opened workbooks?

How to quickly count the number of hidden worksheets in Excel?

Count specific cells

How to count / sum cells based on the font colors in Excel?

How to count / sum strikethrough cells in Excel?

How to count and sum cells based on background color in Excel?

How to count cells by specific formatting such as Bold, Italic in Excel?

How to count cells containing numbers or not in Excel?

How to count cells with specific text and fill/font color in Excel?

How to count number of cells with comments in Excel?

How to count or sum cells based on cell color in Google sheet?

How to count the number of error cells / non error cells in Excel?

How to count the number of shaded cells in Excel?

How to count/sum cells by colors with conditional formatting in Excel?

How to sum / count bold numbers in a range of cells in Excel?

Count with criteria

How to count all cells except a specific value in Excel?

How to count cells beginning with specific letter in Excel?

How to count cells between two times in Excel?

How to count cells if one of multiple criteria met in Excel?

How to count cells match to either X or Y in Excel?

How to count cells that equal to a certain value in Excel?

How to count cells with length greater than a specific number in Excel?

How to count cells with question marks in Excel?

How to count cells with specific text in selection in Excel?

How to count cells with zeros but not blanks in Excel?

How to count cells/records by group in Excel?

How to count data by group in Excel?

How to count how many cells contain certain text or value in Excel?

How to count if cell contains text or part of text in Excel?

How to count if cell does not contain text in Excel?

How to count if cells are nonblank and not equal to specific word in Excel?

How to count if cells are start with or end with specific text in Excel?

How to count if value falls within a given range in Excel?

How to count networkdays between two dates including Saturday in Excel?

How to count number of cells between two values or dates in Excel?

How to count number of cells greater or less than 0 (zero) in Excel?

How to count number of cells with text or number in Excel?

How to count number of cells/rows until first blank in Excel?

How to count number of instances if string length is greater than X in Excel?

How to count number of occurrence in a datetime range in Excel?

How to count records between two dates with matching criteria in Excel?

How to count rows until a certain sum value is reached in Excel?

How to count strings with leading zeros in Excel?

How to count the cells above certain value or average in Excel?

How to count/sum the cells greater than but less than a number?

How to countif a specific value across multiple worksheets?

How to countif absolute values greater/less than given value in Excel?

How to Countif by date/month/year and date range in Excel?

How to countif partial string/substring match in Excel?

How to countif with multiple criteria in Excel?

How to quickly count appearance in every 15 minutes in Excel?

How to quickly count if cells are equal to x or y in Excel?

How to quickly count the number of cells until value changes in Excel?

Others

How to count (identify) and change decimal place in Excel?

How to count files in a certain folder/directory in Excel?

How to count max number of consecutive positive / negative numbers in Excel?

How to count merged cells in selected range in Excel?

How to count number of half hour intervals in Excel?

How to count number of peaks in a column of data in Excel?

How to count number of times a cell is changed in Excel?

How to count or calculate hours worked between times in Excel?

How to count page breaks of active sheet in Excel?

How to count the difference between letters in Excel?

How to count the number of printed pages in a sheet?

How to count the page numbers of Pdf files in Excel?

How to count total clicks in a specified cell in Excel?

How to count total rows in a table in Excel?

How to countif cell values with case sensitive in Excel?

How to countif something is in selected cells in Excel?

How to sum / count checked checkboxes in Excel?

How to sum or count first n values in an Excel column or row?