Question: excel is not blank countif?
Answer: There is another method of using COUNTIF not blank, which counts all selected cells but not blank, by directly editing the cell. For this, go to the edit mode of any cell and press equal “=” sign which will enable all the inbuilt functions of excel. There type COUNTIF and select it, as shown in below screenshot.