Jamie Bohr wrote:
I have a column whose value is any where from 1 to 5. I would like to
count the number of 1, 2, 3, 4 & 5's. For example:
Name score
Sally 4
George 4
Tim 3
Amber 1
Jamie 4
Score break down:
5's 0 <- equation to go here
4's 3
3's 1
2's 0
1's 1
Assuming:
A-column = Name, B-column = score
=COUNTIF(B:B, score)
For example, if you're counting 4's: =COUNTIF(B:B, 4)
--
R | I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:ashley@xxxxxxxxxx> . 303.442.6410 x130
IT Director / SysAdmin / WebSmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.
