All I can say is WOW - you'al are fast ... Thank you, that is exactly what I was looking for <div>On 3/13/06, Antonio Olivares <<a href="mailto:olivares14031@yahoo.com">olivares14031@yahoo.com</a>> wrote:<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> --- Jamie Bohr <<a href="mailto:jamiebohr@gmail.com">jamiebohr@gmail.com</a>> 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 > <a href="mailto:fedora-list@redhat.com">fedora-list@redhat.com</a> > To unsubscribe: <a href="https://www.redhat.com/mailman/listinfo/fedora-list">https://www.redhat.com/mailman/listinfo/fedora-list</a> __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around <a href="http://mail.yahoo.com">http://mail.yahoo.com</a> -- fedora-list mailing list <a href="mailto:fedora-list@redhat.com">fedora-list@redhat.com</a> To unsubscribe: <a href="https://www.redhat.com/mailman/listinfo/fedora-list"> https://www.redhat.com/mailman/listinfo/fedora-list</a> </blockquote></div> -- Jamie Bohr