Mute
datasukaria
Mau menghitung jumlah absensi/kehadiran di Google Sheets? jangan dihitung manual saru per satu. Cukup pakai fitur check box dan rumus COUNTIF, maka akan dihitung otomatis, dan tinggal dicentang aja (lebih interaktif). Jangan lupa follow untuk tips olah data lainnya. Tambahan penjelasan rumus: =COUNTIF(B2:B20,TRUE) B2:B20 → range checkbox yang dicek TRUE → hanya menghitung checkbox yang dicentang Jadi, COUNTIF akan menghitung berapa banyak checkbox yang bernilai TRUE.
Follow
0
0
0
kwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwai