Question

if the value of two is exact how count not empty cells in excel

Answer 1

Microsoft Excel provides several functions purposed for counting different kinds of cells, such as blanks or non-blanks, with number, date or text values, containing specific words or character, etc.

In this article, we will focus on the Excel COUNTIF function that is purposed for counting cells with the condition you specify. First, we will briefly cover the syntax and general usage, and then I provide a number of examples and warn about possible quirks when using this function with multiple criteria and specific types of cells.

In essence, COUNTIF formulas are identical in all Excel versions, so you can use the examples from this tutorial in Excel 2016, 2013, 2010 and 2007.

Excel COUNTIF function - syntax and usage
Examples of how to use COUNTIF in Excel
COUNTIF formula for text and numbers (exact match)
COUNTIF with wildcard characters (partial match)
Count if blank or not blank
Count if greater than, less than or equal to
COUNTIF formulas for dates
Excel COUNTIF with multiple criteria
Count duplicates and unique values
Excel COUNTIF - frequently asked questions and issues