The Formula of COUNT Function many of value1 value2 value 3. If you want to count logical values text or error values use the COUNTA function. Select the cell B9 where COUNT formula needs to be applied.
Method 1 Count Cells With Color Using Filter Method with Sub Total Function Method 2 Count Cells with Color By Creating Function using VBA Code Now let us discuss each of the methods in detail along with an example.
Select Value 1 as a range of cells from A2 to A12. Note that the wildcard represents any number of characters so it doesnt matter how long the name is as long as it ends in y. With the formula SUMIFA2A11yC2C11 I instruct Excel to add up all cells that meet the criteria of having any characters followed by a y. Value2 optional argument We can add up to 255 additional items cell references or ranges within which we wish to count numbers.