In Numbers on a Mac, help me write a formula that shows the percentage of cells in a column that contain an X and the number of cells in the column is 16 please.
HomePod, 27
The parentheses are wrong but it's not really your fault as Numbers will "help" you by introducing its own parentheses when you select a function. (They are the little "crescent" icons you see at the end of your formula above.)
So, let's simplify the formula entry by just specifying the COUNTIF function. In the cell, start typing =COUNTIF. Numbers will then show you this:
Click the green COUNTIF suggestion in green to see this:
Click "test-array" and then select the cells E2 to E17 (my example uses A2 to A17 but it is absolutely the same):
Click "condition" and type "=X", including the quotes:
Press the return key to validate the formula:
In my example, 3 rows contain the value "X", so the function return value is 3, which is displayed as 300%.
If everything looks good, double click the cell (to enter edit mode), type "/COUNT" (without the quotes) and select COUNTA in the suggestion list:
You should see:
Click "value" and select the cells E2 to E17 (my example still uses A2 to A17), you can also type "E2:17" (without the quotes) as selecting the cells can be tricky at this point:
Press the return key to validate the formula:
Just the cell containing the formula. You can also customize the number of decimals by typing "0" so that the percentage is rounded to an integer, or by typing "1" to have only one decimal.
No, you cannot post a file on this forum but you can post a screenshot (if the data is not personal) using the Image Insertion button in the toolbar of your reply:
You are almost there. You missed the = sign. It should read "=X", not "X".
6X6, Yes, now I have a formula that is working but, the answer displayed is 100%, not the actual percent of those that have an X as has voted. Suggestions?
You deserve a medal 6X6 - I can't thank you enough for your patience with me. I wish I had the Numbers intelligence that you have Sir. You are done with me.
It was a pleasure. I’m glad you got things working.
Thanks, Ian!
Okay, I copied each street name, (37) and hit return. The names did not populate and an error message was given. I have sent two photos that I hope define the error.
[Edited by Moderator]
Thank you 6X6, here is my screenshot and the street names are now correctly where they belong. You wanted me to let you know when I got to this point.
When I get to "Now copy cell A2, select cells B3 through B38 and paste the formula:" I am unable to copy A2, see the attached photo.
If you haven't yet modified cells B3 through B38 (to include the division), go to cell B3, copy the cell and paste it in B2. It will restore the COUNTIFS function as it was.
Formula to calculate percentage of cells with 'X' in Numbers for Mac
