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

OT: OpenOffice Calc equation



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
     4's             3
     3's             1
     2's            0
     1's             1
    

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