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

0:15
Up next
"Master Paste Special Format Paste in Excel | Quick Guide" | "How to Paste Formats Only with Paste Special in Excel"
Mr. EXCEL HACKS
2/3/2025
0:13
"Master the PRODUCT Function in Excel | Easy Excel Formula" | "Excel PRODUCT Function | Multiply Multiple Values in Excel"
Mr. EXCEL HACKS
2/3/2025
0:11
"Excel Formula to Find Repeated Numbers in Your Data | Quick & Easy Method" | "Advanced Excel: Find Repeat Numbers & Duplicates in Seconds!"
Mr. EXCEL HACKS
2/3/2025
0:41
How to count cells that contain specific value in Excel? - Excel Tips and Tricks
RabiGurungXybernetics
6/19/2025
0:58
How to Generate Unique Random Numbers in Excel - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
0:58
Convert number to percentage without multiplying by 100 in Excel - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
0:56
Excel Subtotal 9 vs 109 - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
0:56
Sum comma separated values in Excel - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
0:59
How do I return multiple arrays in Xlookup? - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
1:00
VLOOKUP function with curly brackets in Excel | How do I do a VLOOKUP with multiple columns at the same time? - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
1:00
How to use DGET function in Excel with example - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
0:39
Data visualization charts in Excel for analyzing & creating infographs - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
0:54
Create progress bar in excel with percentage - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
0:45
Group & Outline Buttons... Easiest way to Hide & Unhide Rows & Columns - Excel Tips and Tricks
RabiGurungXybernetics
6/2/2025
0:50
How to AutoFit Column Width in Excel | Excel Cells expand to fit text automatically - Excel Tips and Tricks
RabiGurungXybernetics
5/27/2025
1:50
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