Count visible cell (rows) in Numbers

One way to get a quick count of the rows after applying a filter is to do this:

Add a new table to the sheet. (Tap the big + at the upper right and tap a table icon in the table tab).

Select the cells visible after applying the filter in the original table (if you just want a count of the rows it is easier to select the visible cells in only one column), and choose 'Copy' from the bar that pops up.

Tap a cell of the new empty table, and tap 'Paste'.

With the pasted cells still selected after the paste, tap once within the selection area and then tap 'Cell Actions...' in the bar that pops up.

Then tap 'Count' under 'Quick Formula'

The count will appear under the pasted cells.

SG

the only way I know is to add columns to reflect the search criteria, then count the result regardless of filtering.

I entered values 1 thru 4 in column B

Make the first two rows header rows

I also added "filter" conditions for 1 thru 4 in column C thru F.

In cell C1 enter "1"

In cell D1 enter "2"

similar for E1 and F1

C3 = IF($B3=C$1, 1, 0)

this is shorthand for… select cell C3 then type (or copy and paste from here) the formula

=IF($B3=C$1, 1, 0)

select cell C3, copy

select cells C3 thru the end of column F, paste

enter data in column B as shown

C2=SUM(C)

select cell C2, copy

select cells C2 thru F2, paste

now regardless of whether you filer the table count of items matching the criteria

column B = 1 will match the count in cell C2

if the criteria were column B = 2, then the match count would be the count in D2

stevefromcras wrote:

I am on Numbers for Ipad and I don’t think "quick formula" option exist in "cell actions"...

That's on the iPad, after tapping 'Cell Actions'.

On the Mac it's even easier. Just select the cells and look at the count at the bottom of the window.

SG