Mac Numbers - How do I add up cells containing data (text) per column In my Mac Numbers Spreadsheet, I have got a column containing a product title. I would like to add up the cells containing a title at the bottom on my spreadsheet. What formula do I use for that?
Please note: Some of the cells are empty.
This is a job for COUNTIF(). The syntax is not complicated, but it is briefly described here: https://discussions.apple.com/thread/5954557?tstart=0 There are also a number of questions showing how to use it in this SE if you search 'COUNTIF'.