COUNTIF « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. COUNTIF
21.14.COUNTIF
21.14.1.=COUNTIF(A2:A5,A1) return the number of cells with condition in A1=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=COUNTIF(B2:B5,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=COUNTIF(B2:B5,"&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"=COUNTIF(A2:A7,
21.14.5.=COUNTIF(A2:A7,"???e") returns the number of cells ending with the letters "e" and having exactly 4 letters=COUNTIF(A2:A7,
21.14.6.=COUNTIF(A2:A7,"*") returns the number of cells containing text in the first column above=COUNTIF(A2:A7,
21.14.7.=COUNTIF(A2:A7,"<>"&"*") returns the number of cells not containing text=COUNTIF(A2:A7,"&"*") 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>