Skip to main content
Search
Search This Blog
☀️ Learning Ed Tech in English! ☀️
Share
Get link
Facebook
X
Pinterest
Email
Other Apps
Labels
ed tech
Google Sheets
Google Workspace
ICT
online learning
WFH
November 24, 2023
如何在試算表計算學生的不及格學分數
這又是有朋友許願的啦!不過看來也是有此需求!所以把影片錄起來,給有需要的朋友參考喔!
是說時不時動動腦也是很不錯的,歡迎大家在臉書社團許願喔!希望在下這方面還能比AI會一點點!XD
提供影片內公式供參:
=
sumproduct
(
ArrayFormula
(
if
(
V3:Z3
<
60
,
1
,
""
)
)
,
$V$2:$Z$2
)
&
"/"
&
$AA$2
Comments
Popular Posts
August 24, 2025
分享班級座位安排工具
January 31, 2026
新版Google認證教育家考試介紹
Comments
Post a Comment