3/5/2023 0 Comments Openoffice calc countif![]() ![]() Returns 2, because the second, the fifth and the sixth rows do not meet at least one criterion. Returns 3, because the fifth and the sixth rows do not meet the criterion.Ĭounts the amount of rows that contain simultaneously values greater than 70 in the C2:C6 range and values greater than or equal to 20 in the B2:B6 range. In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text.Ĭounts the amount of rows of the range B2:B6 with values greater than or equal to 20. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |