Thank you, that is exactly what I was looking for
On 3/13/06, Antonio Olivares <olivares14031@xxxxxxxxx> wrote:
--- 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
--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
--
Jamie Bohr
