0 0 Votes

LibreOffice/OpenOffice Calc: Count fields with a value greater than X

Question by Compi | 28/04/2020 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?

ReplyPositiveNegative

NetLabel

Show Profile | Message
Avatar
1Best Answer
1 Vote

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:

=COUNTIF(A1:A3;">10")

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.
29/04/2020 at 02:16

ReplyPositive Negative
Reply

Related Topics

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 articles on askingbox.com. How to do.