I have a spreadsheet that is used to enter data on patients. I need to obtain counts of information but cannot get the formula to work. In column A I'm trying to count the number of names. In column B I need to count the number of scores >3. In column C I need to count the number of -1 and the number of 1 answers. I've left the formulas without the = sign so you will see what I've tried.