[Fedora] OT: OpenOffice Calc equation

[Ashley M. Kirchner]

Jamie Bohr wrote:
> 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
>      4's             3
>      3's             1
>      2's            0
>      1's             1
    Assuming:

    A-column = Name,   B-column  = score

    =COUNTIF(B:B, score)

    For example, if you're counting 4's:  =COUNTIF(B:B, 4)

-- 
R | I haven't lost my mind; it's backed up on tape somewhere.
  +--------------------------------------------------------------------
  Ashley M. Kirchner <mailto:ashley at pcraft.com>   .   303.442.6410 x130
  IT Director / SysAdmin / WebSmith             .     800.441.3873 x130
  Photo Craft Laboratories, Inc.            .     3550 Arapahoe Ave. #6
  http://www.pcraft.com ..... .  .    .       Boulder, CO 80303, U.S.A.