Want to know more about how to use Numbers on your Mac?
You can also watch this video at YouTube (but with ads).
MacMost Now 658: Counting Items In iWork Numbers
Comments: 14 Responses to “MacMost Now 658: Counting Items In iWork Numbers”
Comments Closed.
MacMost Online Courses
Keyboard Shortcuts PDF
Fantastic! Just what I was after - clear, concise instruction. Many thanks!
I have ran a mock version of your COUNTIF and COUNTIFS using the same data that you have but I keep getting an error. CountIFS requires that all range arguments and the same size. The column are the same length (size).
what is going on PLEASE?
=COUNTIFS(Table 3 :: A,"=A",Table 3 :: B,"=1",Table 3 :: C=TRUE)
Hard to say without being there. Try again. Try creating your own, etc.
I would like to use iwork numbers template "grade book", but would like to use check-box but keep the weighted %. For example a check represents all (100%) of the weighted 15% and this full credit of the 15% would be considered in the final grade column. Conversely with the non check getting none of the 15% in the final grade column. How does on do this? I hope this make sense?
Not sure what you mean. Would it work to simply use an IF function and award 15 points for a check, 0 otherwise? Then add up all the checkmarks?
I guess I would have the check still be a percentage (0 or full 15%) with other % grades. Then the would go into the total (100%) and letter grade column. Basically grade/no grade but still weighted and tallied to the total and letter grade. Forgive me for not being clear. As you can tell I'm a novice teacher.
This was very helpful thank you! Also is there a way to count words in cells that may have sentences? It only counts them if they are by themselves and some of my cells have a lot of text. Thank you so much
Not sure what you mean by "it only counts them if they are by themselves."
Oh sorry meaning if there is only a single word in the cell.
Oh, I think I see. It sounds like you are asking how to count the number of words in a sentence inside a cell. But I think what you are really asking is how to add up the total number of cells that contain a word.
For that you'd want to use the SEARCH function to figure out if the word is in the cell. So each cell gets a single cell next to it that uses the SEARCH function to figure that out. Then use one of the COUNT-like functions to count those cells that have a positive answer. It will take some work and experimentation.
Yeah that is close to what I am trying to do. I have a spreadsheet that I would like to count how many times a keyword is used. Some cells throughout the spreadsheet have the same keyword used more then one time. For example: "Dance all day and dance all night." this keyword dance might be used in one cell twice. I would like to write a formula that finds my keywords and counts the total used in the entirety of certain columns. Countif only counts when a single word is alone in a cell.
Oh, I see. I'm sure it can be done, but maybe with so much work as to not make it worthwhile. If it was me, I would just export it and open it in BBEdit and then search for the word to see how many it finds. But if you need something that updates constantly then that won't be helpful.
Hi Gary. I'm struggling to make COUNTIF work with a list of dates in Numbers on the iPad. I can make it count words and numbers no problem.
I want to know, for example, how many dates in 2010 are in my data but the count always comes back as 0. If I try to count an exact date like 1st June 2010 it will find those but I just want to count all the 2010s regardless of day and month. Any ideas?
Create another column next to the date. Have it check the date so it is true if in the range, false otherwise. Then COUNTIF for that column.