Calculate attendance figure in Excel using the COUNTIF function
This example should be useful if you deal with a lot of attendance figures and would like to track attendance in a more efficient way. We are presented with an attendance register and are asked to calculate the number of persons present on any given day as well as calculate how many times a person has been present over the given period of the register. You can layout your register like what we did below or create your own. Column A contains the dates and column B uses the user-defined format DDD to determine what day of the week it is. To do this, make sure that Column A2:A11 is formatted as Date and then select B2:B11 and type the formula: =TEXT(A2, “ddd”) and press CTRL+Enter. Each time a person is present, we’ll use the letter “P” to distinguish that. Now that we have that out of the way, here is how we’ll finish the task. This should work in Excel 97, 2000, 2003 and 2007.
How to calculate attendance figures in Excel
- Select cells H2:H11 and type the formula: =COUNTIF(C2:G2,”P”) then Press CTRL+Enter. This will calculate the attendance for any particular day.
- Select cells C13:G13 and type the formula: =COUNTIF(C2:C11,”P”) then Press CTRL+Enter. This will calculate the attendance figure for each person.
That should do it. Please leave a comment if this was helpful to you.
