In our campus life and work life, we usually record everyone’s attendance. Today we will introduce you the application of **Google Sheets ****COUNTIF** function to count the attendance.

Using a week as an example, we use the following example to show you how to use **Google Sheets COUNTIF** function to count attendance.

As shown above, attendance and absence are counted correctly by **Google Sheets COUNTIF** function.

**FORMULA**

In this example, we have used only the **COUNTIF **function, without nesting other functions. In a simple case like the one above, we can use **COUNTIF** function to solve our problem directly.

**COUNTIF** function belongs to **Google Sheets** Statistical functions. It counts the number of cells that meet the provided criterion in a certain range.

Syntax:

=COUNTIF(range, criteria)

In this example, we can directly apply this function with entering our own range and criteria.

=COUNTIF(B2:F2,"√") – in G2

**EXPLANATION**

In this example, the “√” in the cell indicates attendance on the corresponding day. Calculating attendance is equivalent to calculating how many ticks there are in B2:F2.

**FULL ATTENDANCE**

Use G2 as an example, the range for recording attendance is B2:F2. The condition is “√”. So the formula is =COUNTIF(B2:F2,”√”). We cannot enter “√” in this formula, but we can copy a √ into criteria field and include it in brackets.

In the formula bar, we can expand B2:F2, we can get an array of “√”

=COUNTIF({"√","√","√","√","√"},"√")

**Google Sheets COUNTIF** function will count the number of times “√” appears in the array.

Obviously, the result is 5.

**PARTIAL ATTANDENCE**

Copy down the formula. G3 for example, B3 and E3 cells in the absence of “√”, so in this formula, there are only three “√” in the range.

After running the formula, the result is 3.

**ABSENCE**

If the cell is empty, it means it was absent that day. Just replace “√” with “”.

The formula is

=COUNTIF(B2:F2,"")

Note that there are no spaces between the “”. If we enter a space, such as ” “, we will count how many cells in the range B2:F2 contain spaces.

### Related Functions

- Google Sheets COUNTIF function

The**Google Sheets**COUNTIF function will count the number of cells in a range that meet a given criteria. This function can be used to count the different kinds of cells with number, date, text values, blank, non-blanks, or containing specific characters.etc.= COUNTIF (range, criteria)…