M MrYogi Platinum Member Mar 15, 2003 2,680 0 0 Apr 5, 2004 #1 Excel file has column of one of a, b, c, ord d. I need to find out how many times 'a' occured and 'b', and 'c' and 'd'. is there a formula for doing this? No, this is not my homework. I am past that age. Thanks. =COUNTIF($A$1:$A$600,"a")
Excel file has column of one of a, b, c, ord d. I need to find out how many times 'a' occured and 'b', and 'c' and 'd'. is there a formula for doing this? No, this is not my homework. I am past that age. Thanks. =COUNTIF($A$1:$A$600,"a")