Skip to playerSkip to main contentSkip to footer
RabiGurungXybernetics
  • 3/2/2025
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

Recommended

1:50
Up next
FILTER() to extract text and numbers from dataset - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
0:43
Deleting Constants while keeping formulas In Excel - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
0:57
Disable Enable gridlines in Excel - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
3:02
Create a 5 Star Rating System in Excel - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
0:58
How do I calculate days remaining from today in Excel? - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
0:46
How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
1:31
Apply color to alternate rows or columns in Excel - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
1:12
The REAL difference between F4 and Format Painter - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
1:00
How do I alternate column colors in Excel conditional formatting? - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
1:00
How do I alternate row colors in Excel conditional formatting? - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
3:27
How to change bar graph colors in excel based on value - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
0:42
Formula to ignore letters/special characters in cells and only put numbers - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
0:54
How to do partial match with FILTER function - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
1:01
FILTER function multiple columns in Excel - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
0:48
How do I turn off structured references in Excel? - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
1:33
4 Ways to hide a row - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
1:47
Copy Only Visible Cells - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
1:00
SUPER EASY Excel Data Entry Form (NO VBA) - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
2:16
Create a Simple User Data Entry Tool - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
0:10
What is the shortcut for today date and time? - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
1:19
How to Make Borders Automatically Appear as Data is Added - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
1:57
How do I find the Top 3 highest values in Excel? - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
1:15
Conditional formatting for entire row based on data in one cell | How do I highlight rows in Excel based on yes or no - Excel Tips and Tricks
RabiGurungXybernetics
5/16/2025
4:02
How to highlight row cell containing partial text - Excel Tips and Tricks
RabiGurungXybernetics
5/1/2025
1:20
Using Alt + Down Arrow to Speed Up Data Entry - Excel Tips and Tricks
RabiGurungXybernetics
5/1/2025