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