=COUNTIF(B2:B5,"<>"&B4) returns the number of cells with a value not equal to the value in B4 : COUNTIF « Statistical functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Statistical functions
3. COUNTIF

Input the formula: =COUNTIF(B2:B5,"<>"&B4). Press Enter to get the result.

21.14.COUNTIF
	21.14.1.	=COUNTIF(A2:A5,A1) return the number of cells with condition in A1
	21.14.2.	=COUNTIF(B2:B5,">55") return the number of cells with a value greater than 55	55") return the number of cells with a value greater than 55" src="http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/countifb2b5gt55_Return_Number_Of_Cells_With_V___Input_Formula_countifb2b555.PNG" width=200 height=40>
	21.14.3.	=COUNTIF(B2:B5,"<>"&B4) returns the number of cells with a value not equal to the value in B4	"&B4) returns the number of cells with a value not equal to the value in B4" src="http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/countifb2b5ltgtampb4returns_Number_Of_Cell___Input_Formula_co2b5b4.PNG" width=200 height=40>
	21.14.4.	=COUNTIF(A2:A7,"*e") returns the number of cells ending with the letters "e"
	21.14.5.	=COUNTIF(A2:A7,"???e") returns the number of cells ending with the letters "e" and having exactly 4 letters
	21.14.6.	=COUNTIF(A2:A7,"*") returns the number of cells containing text in the first column above
	21.14.7.	=COUNTIF(A2:A7,"<>"&"*") returns the number of cells not containing text	"&"*") returns the number of cells not containing text" src="http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/countifa2a7ltgtamp_Returns_Number_Of_Cel___Input_Formula_countifa2a7.PNG" width=200 height=40>