Mac Numbers - How do I add up cells containing data (text) per column
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'.