Excel Tips and Tricks - Online Attendance Sheet With Checkbox In Google Sheet

Excel Tips and Tricks - Online Attendance Sheet With Checkbox In Google Sheet

Learn how to create an online attendance sheet with checkbox in Google Sheet and also count how many days a person attended.

Here is the formula.

Add checkbox
1) Select cells
2) Insert -- Checkbox

Add Attendance Count
1) Select cell
2) Enter formula
=COUNTIF(B3:F3,true)
3) Copy past to all cells

excel countif multiple criteria,excel countif text,excel countif not blank,excel countif greater than,excel countif multiple criteria different column,excel countif multiple criteria same column,excel countifrange,advanced countifs function in excel,

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips