Excel Formulas to use Basic attendance tracking formula in Excel!!
Tags: excelformula, excelformulas
Published: 2021-10-30 11:06:59

---
title: Excel Formulas to use Basic attendance tracking formula in Excel!!
published: true
date: 2021-10-30 05:52:05 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-use-basic-attendance-tracking-formula-in-excel/
---

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](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.

![](https://geekexcel.com/wp-content/uploads/2021/10/Sample-data-73-1024x245.png)<figcaption>Sample data</figcaption>

- 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](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=COUNTIF(C5:L5,"x")

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-Formula-25-1024x315.png)<figcaption>Use the Formula bar</figcaption>

- After that, you need to **Hit**  the  **Enter**  key to get the **result** as shown below.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-for-the-cell-1-1024x311.png)<figcaption>Result for cell M5</figcaption>

- You have to **press Ctrl+D Key** to get the value in the entire present column.

![](https://geekexcel.com/wp-content/uploads/2021/10/Entire-Present-column-1024x330.png)<figcaption>Get the value in the entire present column</figcaption>

- To track attendance for absent, you have to apply the below-given formula in **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=COUNTIF(C5:L5,"x")

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-Formula-1-2-1024x309.png)<figcaption>Use the Formula</figcaption>

- Now, you need to **Hit**  the  **Enter**  key to get the **result** as shown below.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-for-absent-col-1-1024x309.png)<figcaption>Result for the cell N5</figcaption>

- Finally, you have to **press Ctrl+D Key** to get the value in the entire absent column.

![](https://geekexcel.com/wp-content/uploads/2021/10/Entire-value-for-absent-1024x330.png)<figcaption>Get the value in the entire absent column</figcaption>

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[How to Move Range in Microsoft Excel 365?](https://geekexcel.com/how-to-move-range-in-microsoft-excel-365/)**
- **[Excel Formulas to find Average last N values in a table in Excel!!](https://geekexcel.com/excel-formulas-to-find-average-last-n-values-in-a-table-in-excel/)**
- **[How to change Font Size in Excel Office 365? ~ Simple Steps](https://geekexcel.com/how-to-change-font-size-in-microsoft-excel-365/)**
- **[Easy ways- {Insert Sheet} in Microsoft Excel 2013!!](https://geekexcel.com/easy-ways-insert-sheet-in-microsoft-excel-2013/)**
- **[Excel Formulas to Find Last Row Number in a Range in Excel 365!!](https://geekexcel.com/excel-formulas-to-find-last-row-number-in-a-range-in-excel-365/)**