I need to know how many cells I have selected in Numbers

I need to know how many cells I have selected


[Re-Titled by Moderator]

iPad Pro, iPadOS 17

Posted on May 4, 2024 8:22 PM

Reply
5 replies

May 5, 2024 6:03 AM in response to ccinseward

Use the bar of formulas at the bottom of the screen.


If all of the selected cells have something in them (none are blank), COUNTA will give you the count. If COUNTA is not there, use the gear to include it. It will give you a count of all non-empty cells in your selection (of 2 or more cells), but it will not count any empty/blank cells.


If all of the selected cells are blank, with absolutely nothing in them, you can do the same as above using COUNTBLANK.


If your selection is a mix of filled and blank cells, you can get a full count by looking at both of those functions. Just add them together in your head. It might be a good idea to do this in any case because sometimes a cell that looks blank may not actually be blank. For example, a space character looks blank but it not.

I need to know how many cells I have selected in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.