In this tutorial, we are going to look at how to use the basic attendance tracking formula in Excel Office 365. We will show you the easy steps for completing the task quickly. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula
- You can use the below-mentioned formula to use the basic attendance tracking formula in Excel.
=COUNTIF(range,"x")
Syntax Explanation
- COUNTIF – This function counts the number of cells in a range that meets a given criterion.
- *Parenthesis () *– The purpose of this symbol is to group the elements.
- **Comma symbol (,) – **It is a separator that helps to separate a list of values.
- *Rng * – It represents the input range.
Practical Examples
Use the following steps to use the basic attendance tracking formula in Excel.
- In the following example, you have to create a sample input values in Excel.
- Then, you need to select a cell where you want to place the result.
- Now, to track attendance for present, you have to apply the below-given formula in formula bar.
=COUNTIF(C5:L5,"x")
- After that, you need to Hit the Enter key to get the result as shown below.
- You have to press Ctrl+D Key to get the value in the entire present column.
- To track attendance for absent, you have to apply the below-given formula in formula bar.
=COUNTIF(C5:L5,"x")
- Now, you need to Hit the Enter key to get the result as shown below.
- Finally, you have to press Ctrl+D Key to get the value in the entire absent column.
Closure
In this tutorial, we guided you to know how to use the basic attendance tracking formula in Excel Office 365 with proper examples and screenshots. Kindly, give your feedback in the below comment section.
Thanks for visiting Geek Excel!! *If you want to learn more helpful formulas, check out Excel Formulas *!!
Read Ahead:
Top comments (0)