---
description: 非空白格子數
---

# Count non-blank cells

{% tabs %}
{% tab title="💈範例" %}
```excel-formula
// count non-blank cells
=SUMPRODUCT(LEN(A1:A13)>0)
```
{% endtab %}

{% tab title="📗 參考" %}
* [ProductivitySpot](https://productivityspot.com/) ⟩ [How to Count Cells If Not Blank in Google Sheets](https://productivityspot.com/count-non-blank-cells-google-sheets/)
* [Google Sheets: Array Lesson 2: 陣列-交集-單值 (Array-Intersection-Single value)](https://roamingforstory.blogspot.com/2016/08/google-sheets-array-lesson-2-array.html) ⭐️
{% endtab %}

{% tab title="📘 手冊" %}
* Google Sheet ⟩&#x20;
  * [SUMPRODUCT](https://support.google.com/docs/answer/3094294?hl=en) - 其實就是數學的「內積」運算 (inner product or dot product)。&#x20;
  * [LEN](https://support.google.com/docs/answer/3094081?hl=en) - string length
{% endtab %}
{% endtabs %}
