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
