LibreOffice/OpenOffice Calc: Count fields with a value greater than X
Question by Compi | 2020-04-28 at 19:56
Is there a way in the spreadsheet program Libre Office Calc to determine the number of fields whose numerical value is greater than a comparison value? For example, the number of cells whose value is greater than 10. Is that possible?
Related Topics
jQuery: Count characters from multiple input fields
Tip | 0 Comments
Send Form Input as an Array to PHP Script
Tip | 0 Comments
LibreOffice/OpenOffice Calc: Count fields with a specific content
Question | 1 Answer
OpenOffice Calc: Line Break within a Cell
Question | 1 Answer
Color Values: Convert RGB, CMYK, CMY, HSV, TColor and XYZ Values
Tutorial | 0 Comments
Determine Word Frequencies of a Text
Tutorial | 0 Comments
MySQL: GROUP BY range - Count small, medium and large data sets
Tip | 0 Comments
Important Note
Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.
Participate
Ask your own question or write your own article on askingbox.com. That’s how it’s done.
In both LibreOffice and OpenOffice you can use the function COUNTIF() to count fields. The field range for the counting and the comparison condition have to be written into the brackets. That is for your example:
Here we specified the range A1 to A3 and the comparison condition > 10. That means you get the number of fields with a value greater than 10 from the fields A1, A2 and A3. So for example 3 if all 3 fields have a value over 10.
2020-04-29 at 02:16