--- Jamie Bohr <jamiebohr@xxxxxxxxx> wrote: > This message is very off topic - sorry. I did not > want to have to look for > and sign up for yet another mailing list when I have > what I hope is an easy > question for someone in the know ;) > > 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 COUNTIF(FROMCELLRANGE:TOCELLRANGE;5) > 4's 3 <- COUNTIF(FROMCELLRANGE:TOCELLRANGE;4) > 3's 1 <- COUNTIF(FROMCELLRANGE:TOCELLRANGE;3) > 2's 0 <- COUNTIF(FROMCELLRANGE:TOCELLRANGE;2) > 1's 1 <- COUNTIF(FROMCELLRANGE:TOCELLRANGE;1) > > COUNTIF(FROMCELLRANGE:TOCELLRANGE;number to count) should do the job for you. Hope this helps, Antonio > -- > Jamie Bohr > > -- > fedora-list mailing list > fedora-list@xxxxxxxxxx > To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
