00 Votes

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?

ReplyPositiveNegative
Avatar
1Best Answer1 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.
2020-04-29 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 article on askingbox.com. That’s how it’s done.