Mac Numbers: How to count selected rows

Question

Level 1

12 points

Mac Numbers: How to count selected rows

How can I count the number of rows I've selected in Mac Numbers? I don't want to add a formula on the sheet that I would have to keep modifying anyway; I just want to be able to select a span of rows -- or rows selected independently -- and see the total number of rows.

I checked the bottom of the spreadsheet that provides SUM, AVERAGE, MIN, MAX, etc. but none of the options in the cog wheel settings offers something like a simple selected row count.

Is there a way to do this without having to use a formula? I have large spreadsheets and often (almost daily) have to select and count rows for a variety of reasons.

Thank you in advance for your help!

Posted on Aug 5, 2022 6:28 AM

Reply

Answer 1

Badunit

Level 7

30,192 points

Aug 6, 2022 7:27 PM in response to krislynch

If in each row you select a non-blank cell instead of choosing the entire row, the COUNTA function at the bottom will tell you how many rows were selected. All data and formulas count as non-blank, even if the formula result is the null string "" and looks blank.

Reply

Answer 2

krislynch Author

Level 1

12 points

Aug 5, 2022 6:36 AM in response to krislynch

UPDATE: I see that I can select the rows, then go to TABLE, then look for 'Hide xx rows' to get the number. I suppose that's an easy enough work-around but I'd still like to know if there's a way to add this to the very bottom of a spreadsheet along with the SUM, AVERAGE, MIN, MAX options.

Reply

Answer 3

SGIII

Level 8

37,442 points

Aug 5, 2022 7:45 AM in response to krislynch

I think your Table > Hide x Rows is the best solution. Thanks for pointing that out.

SG

Reply

Mac Numbers: How to count selected rows

Similar questions