Akehyfm

 COUNTIF Not Blank function is used for counting of any defined number/text range of any column without considering any blank cell This becomes possible only by using the COUNTIF function, which follows the defined criteria to get the desired output Syntax for COUNTIF Not Blank in Excel The COUNTIFS function can count the values in multiple ranges with multiple criteria The function counts each given rangecriteria pair and combines the result with AND logical operator Unfortunately, there is no quick and easy way to use an OR logic with the function On the other hand, you can an OR logic between two negative logical values equals to an ANDThe & operator joins the 'not equal to' operator and the text value in cell C1 6 The COUNTIFS function below counts the number of cells in the range A1A5 that are not equal to "red" and not equal to "blue" Explanation the COUNTIFS function in Excel counts cells based on two or more criteria This COUNTIFS function has 2