## 'Count values' category

How to sum overlapping time

The worksheet above shows four different time ranges in column B and C, the formula in cell C10 counts the […]

The worksheet above shows four different time ranges in column B and C, the formula in cell C10 counts the […]

Count cells containing text from list

The array formula in cell F3 counts cells in column B that contains at least one of the values in […]

The array formula in cell F3 counts cells in column B that contains at least one of the values in […]

Count unique distinct values based on a condition

This article demonstrates how to construct a formula that counts unique distinct values based on a condition. The image above […]

This article demonstrates how to construct a formula that counts unique distinct values based on a condition. The image above […]

Count cells based on background color programmatically

This article demonstrates a VBA macro that counts cells based on their background color. What's on this page Question VBA […]

This article demonstrates a VBA macro that counts cells based on their background color. What's on this page Question VBA […]

Count identical values if they are on the same row

This article describes a formula that counts values in two columns if they are duplicates on the same row. What's […]

This article describes a formula that counts values in two columns if they are duplicates on the same row. What's […]

Count overlapping days across multiple date ranges

This post demonstrates a formula in cell D16 that counts overlapping dates across multiple date ranges. The date ranges are […]

This post demonstrates a formula in cell D16 that counts overlapping dates across multiple date ranges. The date ranges are […]

Count overlapping days in multiple date ranges, part 2

In the previous post I explained how to count overlapping dates comparing a single date range against multiple date ranges. […]

In the previous post I explained how to count overlapping dates comparing a single date range against multiple date ranges. […]

Count overlapping days in multiple date ranges

The MEDIAN function lets you count overlapping dates between two date ranges. If you have more than two date ranges […]

The MEDIAN function lets you count overlapping dates between two date ranges. If you have more than two date ranges […]

How to count repeating values

This article demonstrates ways to count contiguous values in a column, in other words, values that repeat and are adjacent. […]

This article demonstrates ways to count contiguous values in a column, in other words, values that repeat and are adjacent. […]

How to count the number of values separated by a delimiter

This article demonstrates formulas that count values in cell based on a delimiting character. The image above shows a formula […]

This article demonstrates formulas that count values in cell based on a delimiting character. The image above shows a formula […]

Count Conditionally Formatted cells

This article explains how to count cells highlighted with Conditional Formatting (CF). The image above shows data in cell range […]

This article explains how to count cells highlighted with Conditional Formatting (CF). The image above shows data in cell range […]

Count cells based on background color

This article demonstrates techniques on how to count cells based on the background color. I will also demonstrate user defined […]

This article demonstrates techniques on how to count cells based on the background color. I will also demonstrate user defined […]

Count unique distinct values in a filtered Excel defined Table

This article demonstrates a formula that counts unique distinct values filtered from an Excel defined Table. Debra Dalgleish described in […]

This article demonstrates a formula that counts unique distinct values filtered from an Excel defined Table. Debra Dalgleish described in […]

Count groups of repeated values per row

Joe asks: I have a worksheet that has rows, each containing sequential groupings of values of "1" and "0". These […]

Joe asks: I have a worksheet that has rows, each containing sequential groupings of values of "1" and "0". These […]

Count weekday within date range except holidays

Steve asks: Right now I'm using the following formula to tell me how many of a specific defined day, ie […]

Steve asks: Right now I'm using the following formula to tell me how many of a specific defined day, ie […]

Count cells between specified values

This article demonstrates formulas that calculate the number of cells between two values, the first scenario involves two search values […]

This article demonstrates formulas that calculate the number of cells between two values, the first scenario involves two search values […]

Count entries based on date and time

Question: My issue is that I get the date in this format: 7/23/2011 7:00:00 AM I am trying to count […]

Question: My issue is that I get the date in this format: 7/23/2011 7:00:00 AM I am trying to count […]

Count unique distinct values that meet multiple criteria

This post demonstrates how to build an array formula that counts unique distinct values based on criteria. What's on this […]

This post demonstrates how to build an array formula that counts unique distinct values based on criteria. What's on this […]

Count unique distinct records with a date and column criteria

davidlim asks: re: Count records between two dates and a criterion based on the example, i was looking for 1 […]

davidlim asks: re: Count records between two dates and a criterion based on the example, i was looking for 1 […]

Count digits and ignore duplicates

Question: I have a question that I canâ€™t seem to find an answer to: I want to make a full […]

Question: I have a question that I canâ€™t seem to find an answer to: I want to make a full […]

Count cells based on a condition and month

Janib Soomro asks: In A column, there are dates in mmddyyy format and in B column, there are two variables […]

Janib Soomro asks: In A column, there are dates in mmddyyy format and in B column, there are two variables […]

Count groups in calendar

Question: Sam asks: Is there a formula that can count blocks For eg in your picture (see picture above) if […]

Question: Sam asks: Is there a formula that can count blocks For eg in your picture (see picture above) if […]

Count unique distinct values within same week, month or year

The array formula in cell E3 counts unique distinct items for all dates within the same week. Example, week 2 […]

The array formula in cell E3 counts unique distinct items for all dates within the same week. Example, week 2 […]

How to count unique distinct values based on a date

The array formula in cell D3 calculates the number of unique distinct items based on the given date in columnÂ B. […]

The array formula in cell D3 calculates the number of unique distinct items based on the given date in columnÂ B. […]

Count unique distinct numbers across multiple sheets

The image above demonstrates three different formulas in column E that counts unique numbers unique distinct numbers duplicate numbers from […]

The image above demonstrates three different formulas in column E that counts unique numbers unique distinct numbers duplicate numbers from […]

Count cells between two values

The formula in cell E16 counts the number of cells between valueÂ B and H, Value B is in cell B3 […]

The formula in cell E16 counts the number of cells between valueÂ B and H, Value B is in cell B3 […]

Most frequent value between two dates

I will in this article show you how to extract the most frequent value (text or number) between two dates […]

I will in this article show you how to extract the most frequent value (text or number) between two dates […]

Count unique distinct months

The formula in cell D18 counts unique distinct months in cell range B3:B16. Formula in D18: =SUMPRODUCT((FREQUENCY(DATE(YEAR($B$3:$B$16), MONTH($B$3:$B$16), 1), DATE(YEAR($B$3:$B$16), […]

The formula in cell D18 counts unique distinct months in cell range B3:B16. Formula in D18: =SUMPRODUCT((FREQUENCY(DATE(YEAR($B$3:$B$16), MONTH($B$3:$B$16), 1), DATE(YEAR($B$3:$B$16), […]

Count unique distinct values

This article describes how to count unique distinct values. What are unique distinct values?Â They are all values but duplicates are […]

This article describes how to count unique distinct values. What are unique distinct values?Â They are all values but duplicates are […]

## Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values