I am used to using ISNUMBER in Excel. I just want to ask a column how many cells contain text or how many contain numbers, either way. I am trying to make a graph saying 35% of cells in column contain text data and 65% contains number data.
iPad Pro, iPadOS 17
Let's say that you're talking about Column B.
=COUNTA(B) will count all the column B cells that aren't empty in the body rows (not Header or Footer Rows).
=COUNT(B) will count all the cells that contain numeric expressions, numbers, or dates in the body rows (not Header or Footer Rows).
So, =COUNT(B) will give you the number of cells that contain number data and =COUNTA(B) - COUNT(B) will give you the number of cells containing text.
This assumes that you don't have Dates in column B.
Jerry
Let's say that you're talking about Column B.
=COUNTA(B) will count all the column B cells that aren't empty in the body rows (not Header or Footer Rows).
=COUNT(B) will count all the cells that contain numeric expressions, numbers, or dates in the body rows (not Header or Footer Rows).
So, =COUNT(B) will give you the number of cells that contain number data and =COUNTA(B) - COUNT(B) will give you the number of cells containing text.
This assumes that you don't have Dates in column B.
Jerry
Hi excel2numbers,
Type = in any cell to bring up the Function Browser.
Well worth exploring.
For example, the Logical & Info functions include ISNUMBER and ISTEXT among other functions.
More information here (Numbers > Menu > Help > Formulas and Functions Help).
Regards,
Ian.
Thanks that did the trick!
Thanks for the feedback. Good luck with your project.
How to ask a column how many cells contain text v numbers
