Attendence list in Excel

In this tutorial we will learn attendence list using Excel.
We will use Countif function in this tutorial.
1.Example:
   x means present.
   Blank cells showing absent.

   

2.Example:We can also count absent days by using Countif        function as shown in below image.

We can see in following image that employee ID 706 have only 1 absent.Inverted commas "" in formula count blank cells

IFERROR function

In following image VLOOKUP function used to find the required data.
For Example If we enter john it shows the result of john's data.

But if we enter the name which is not listed then it shows #N/A.To avoid #NA, IFERROR function can be used.

By using IFERROR function we can show our desired message.You can see it in below image.