Libre Office Calc
Function I used for calc by criteria – COUNTIF
COUNTIF – counts the number of cells in a range that meet a specified condition.
test_range is the range to be tested.
condition may be:
a number, such as 34.5
an expression, such as 2/3 or SQRT(B5)
a text string
COUNTIF counts those cells in test_range that are equal to condition, unless condition is a text string that starts with a comparator: ‘>, <, >=, <=, =, <>’
In this case COUNTIF compares those cells in test_range with the remainder of the text string (interpreted as a number if possible or text otherwise).
For example the condition “>4.5” tests if the content of each cell is greater than the number 4.5, and the condition “<dog” tests if the content of each cell would come alphabetically before the text dog.