Quick, clean, and to the point

Basic attendance tracking formula

Excel formula: Basic attendance tracking formula
Generic formula 

One way to track attendance is with simple formulas based on the COUNTIF function. In the example shown, the formula in M5 is:


This formula simply uses COUNTIF with a criteria of "x" (not quotation marks) to count x's in each row, where "x" represents "present" and an empty cell represents "absent":

=COUNTIF(C5:L5,"x") // count present

The count absent days, the worksheet uses COUNTIF again, configured to count empty cells:

=COUNTIF(C5:L5,"") // count absent
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.