非空白格子數
Last updated 2 years ago
Was this helpful?
// count non-blank cells =SUMPRODUCT(LEN(A1:A13)>0)
⟩
⭐️
Google Sheet ⟩
- 其實就是數學的「內積」運算 (inner product or dot product)。
- string length