This is quite useful… putting it here coz I keep forgetting the syntax 🙂

To use another cell as part of your comparison criteria in Open Office Calc functions like COUNTIF or SUMIF:

=COUNTIF(A1:A10; “<“&B1)

THe above will count how many values in the range A1..A10 are less than the value contained in B1. So […]