for example cell a1: silver a2: bronze a3: black a4: red a5: brown a6: brown
B BenjieLop Sep 27, 2004 #3 Enter this in Cell A11 =countif(A1:A10,"brown") or more generally, =countif(A1:A10,your_color_choice)
Enter this in Cell A11 =countif(A1:A10,"brown") or more generally, =countif(A1:A10,your_color_choice)