OT: OpenOffice Calc equation

[Jamie Bohr]

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 at yahoo.com> wrote:
>
> --- Jamie Bohr <jamiebohr at 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 at 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 at redhat.com
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>



--
Jamie Bohr
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20060313/a93ed5e1/attachment-0001.htm>