Talk:Documentation/Calc Functions/COUNTIFS

    From The Document Foundation Wiki

    SF comments

    (1) Syntax. Please align with syntax given in Help.
    (2) Returns. Presumably, it will be a non-negative integer.
    (3) Arguments, 2nd paragraph. Would it be worth clarifying that if you put the criteria in a cell as a sting, quotation marks don’t appear to be required?
    (4) Arguments, 3rd and 4th paragraphs. Suggest “Range1” and “Criterion1” should be bold.
    (5) Arguments, 1st bullet point. Is it Range1 … Range127 that need to be the same size? Is the mention of Criterion1, Criterion2, ... relevant in this context?
    (6) Additional details. No statement about whether the behaviour of this function is affected by the setting of the option “Search criteria = and <> must apply to whole cells” in Tools > Options > LibreOffice Calc > Calculate.
    (7) Examples, Simple usage table. Change “amount” to “number” in both rows.
    (8) Examples, Using regular expressions and nested functions table. Change “amount” to “number” in all rows. In first row, change “the only” to “only the”. In third row, insert “the” before “second”. There is no indication of which options need to be set in Tools > Options > LibreOffice Calc > Calculate in order to get the correct return for each example (I think 1st and 3rd need regular expressions enabled; 2nd will work for any setting).
    (9) Examples, Using wildcard characters table. No statement about the purpose of the tilde (~). It would be worth mentioning how you enable wildcards. Change “what” to “which”. Change “row” to “rows”.

    --Stevefanning (talk) 2020-10-14T13:32:55 (UTC)

    Replying

    All comments addressed.

    5. is mentioned in help.

    6. need more understanding of this and hence need to do some research.

    --Ronnie rg8888 (talk) 2020-11-14T11:38:22 (UTC)