In this article, we will learn about how to Count cells that equals either A or B value using COUNTIF function in Excel. In simple words, Consider a scenario in which we are required to count the data based on specific criteria in an array. counting cells that have either A or B value using the wildcards to catch cell value with countif function in excel explained here with an example. The COUNTIF function returns the count of cells which have either Value 1 or value 2. Generic formula:
Range : array Value1 : value in quotes + : OR operator with COUNTIF Wildcard characters for catching strings and perform functions on it. There are three wildcard characters in Excel
Let’s understand this function using it in an example. There are different shades of colours in the array. We need to find the colours which have either Blue or red. Use the formula:
A2:A13 : array *red* : matches cells where red exist + : operator to concatenate results The formula drops down to =6 (Blue)+3 (red) = 9 There are 9 cells which have either Blue or red. As you can see the COUNTIF formula returns the count of cells which do not have a specific value. Hope you understood how to Count cells which match either A or B in Excel. Explore more articles on Excel text functions here. Please feel free to state your query. We will surely assist you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.