Ulet 使用指南

開始使用 Mac 版 Ulet。

Count Matching Rows With COUNTIF in Ulet on Mac

Use COUNTIF when the rows already have a category and you need to count just one group.

Count one category

  1. Enter the region names in D2:D4. The sample has West, East, West.

  2. Select D6 and enter =COUNTIF(D2:D4,"West"). Press Return.

  3. Save the workbook.

The region column before entering the count.

The region column before entering the count.

Compare with a manual count

In the sample, the result is 2 because two rows say West. If the count is lower than expected, inspect the category text in the input cells and verify the range includes every intended row.

The saved COUNTIF result for West.

The saved COUNTIF result for West.

Related guide open and save an XLSX workbook.

Steps checked in the Mac desktop editor with a practice file, including saving and reopening. Screenshots show the Ulet editor; the test used an isolated profile and file-picker fixtures.

Ulet

一套滿足日常工作需要的綜合辦公軟件。

查看功能