[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: OT: OpenOffice Calc equation



All I can say is WOW - you'al are fast ...

Thank you, that is exactly what I was looking for



On 3/13/06, Antonio Olivares <olivares14031 yahoo com> wrote:
--- Jamie Bohr <jamiebohr gmail com> 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 redhat com
> 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 redhat com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list



--
Jamie Bohr
[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]