I set up a sheet with a column of text values and used COUNTIF to count the number of each variable. The format was =countif(b2:b59,"2A"). This worked fine until I copied it to another similar spreadsheet. I adjusted the cell references, etc., but it returns a value of 0.0. I tried deleting the formula and typing it in from scratch and it still doesn't work. Does anybody know what's going on here?