非空白格子數
// count non-blank cells =SUMPRODUCT(LEN(A1:A13)>0)
ProductivitySpotarrow-up-right ⟩ How to Count Cells If Not Blank in Google Sheetsarrow-up-right
Google Sheets: Array Lesson 2: 陣列-交集-單值 (Array-Intersection-Single value)arrow-up-right ⭐️
Google Sheet ⟩
SUMPRODUCTarrow-up-right - 其實就是數學的「內積」運算 (inner product or dot product)。
LENarrow-up-right - string length
Last updated 3 years ago