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

Re: OT: OpenOffice Calc equation



--- 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 


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