What is countif function?

The Countif function is a function in Microsoft Excel that counts cells in a specified range that meet specified conditions. It can be used in WPS, Excel2003 and Excel2007 and other versions.

The syntax rules of this function are as follows:

countif（range，criteria）

Parameters: range The range in which the number of non-empty cells is to be calculated

Parameters: criteria defined in the form of numbers, expressions or text

Usage

1. Find the individual values ​​of various types of cells Number

(1) Find the number of vacuum cells: =COUNTIF(data area,"")

(2) Find the number of non-vacuum cells: =COUNTIF(data area ,"a8093152e673feb7aba1828c43532094") is equivalent to the counta() function

(3) Number of text-type cells: =COUNTIF(data area,"*") False empty cells are also text-type cells

(4) Number of all cells in the range: =COUNTIF(data area, "a8093152e673feb7aba1828c43532094"""), if there is " in the data area, this formula is not valid.

( 5) The number of cells with a logical value of TRUE = COUNTIF (data area, TRUE)

2. Find the number of cells that are greater than or less than a certain value

(1) Greater than 50=COUNTIF(data area,">50")

(2) Equal to 50=COUNTIF(data area,50)

(3) Less than 50 =COUNTIF( Data area, "ea1074997a741c4bda2cc68689439848=50")

(5) Less than or equal to 50 =COUNTIF (data area, "34d51273ea0edfa37b11d9a652d1e55d"&$E$5)

(7) Equal to the value of cell E5=COUNTIF(data area,$E$5)

(8) Less than the value of cell E5=COUNTIF(data area,"e08f15c02cddf8fef64dc4d47bc8f7b5="&$E$5)

(10) Less than or equal to the value of cell E5=COUNTIF(data Area,"f13165ce6eecfc2cff4964415baec9f310 and80f0bce571a92bb9b70e6bfbf06a1c53 "&{10,15})*{1,-1}) or =SUM(COUNTIF(data area,"961e13df7e9e6ff214f30d9658f9facf=10ande33ca207a5f4f4190d2b6eab5bb06194="&{10,15})*{1,-1}) or =SUM(COUNTIF(data area," 43432587de732fa7ac23c8dc0766f544=10 andebbc35af162f5510a5555f795885ff15=10 ",">15"})*{1,-1})

(4)>10andd83f7600ace0a72a94a61b3929f3e1c610","> ;=15"})*{1,-1}) or =SUM(COUNTIF(data area,{">10","b1fe49f1012a888dcda7aff4401cf20c=60"))

Supplement: (Set operation method)

The statistical range, for example, 56432a31756cd62485fb2cf57812c3ec5 =5)-(x>7)

Write as a function:

=countif(range,">=5")-countif(range,">7")

In this way, you can use the operation knowledge of sets. It also achieves the purpose of finding the same number in the above two conditions, and is simpler and easier to understand.

The above is the detailed content of What is countif function?. For more information, please follow other related articles on the PHP Chinese website!