Basic attendance tracking: To track the records and calculate the overall attendance of a student, here’s what to do:

Attendance Tracking Formula

As you can observe in the image above, we have shown few roll numbers and their attendance of one week i.e. from Monday to Friday.

Now to calculate the no. of days a particular student was present on, or absent on, here’s what we do:

Attendance Tracking Formula

Step 1: Input the formula =COUNTIF(

As we are going to count the no. of days the particular student was present, we will use the COUNTIF Function for the same.

The following function is as follows:

=COUNTIF(

Step 2: Input the required values in the formula

The following formula requires range as well as criteria.

Attendance Tracking Formula

The range will be the no. of days i.e. B3:F3.

Attendance Tracking Formula

Then we will come to the point of criteria. As we have written P below the days the particular student was present, so our criteria will be the same. But the thing is, we cannot just select any cell which has P in it.

Instead we will directly write P but in quotations marks, by this we are adding particular specifications to the formula.

So, it has to be written as:

“P”

Attendance Tracking Formula

Step 3: Cross- check the formula and proceed

By now, our overall formula becomes as follows:

=COUNTIF(B3:F3,”P”)

Attendance Tracking Formula

Now all we have to do is press enter and BAAAAMMMM! The answer is 4. This means that the Roll No. 321 was present on 4 days out of 5.

To find out the no. of days the rest of the students were present on, simply drag down the formula till it’s requires just like it is shown in the image above.

Attendance Tracking Formula

Now, we will count the no. of days the students were absent on.

Step 4: Input the formula =COUNTIF( again

We will input the COUNTIF Function which is as follows:

=COUNTIF(

Step 5: Input the required values in the formula

The following formula will require a range as well as a criteria to follow.

We will select the range, like we did before, which makes it B3:F3.

Attendance Tracking Formula

Then in the case of criteria, we will leave the quotation marks empty. This is because, the no. of days the students were absent on, nothing was written instead the day was left blank.

Attendance Tracking Formula

Step 6: Cross- check the formula and proceed

So, after inputting the criteria, we will close the COUNTIF Function. By now, our overall formula becomes as follows:

=COUNTIF(B3:F3,””)

Attendance Tracking Formula

Now all you have to do is press enter and drag down the formula till it’s required.

Attendance Tracking Formula

There you go, the basic attendance tracking formula. This type of formula can be used in corporations to keep a check on the employees to make sure that they are not exceeding their paid leaves or permitted leaves.

Attendance Tracking Formula

It’s easy, isn’t it?