Talk:Documentation/Calc Functions/AVERAGEIF

    From The Document Foundation Wiki

    SF comments

    (1) Arguments. In the first paragraph is it worth clarifying that the meaning of this argument is dependent on the existence of the Average_Range argument?
    (2) Arguments. Are there any specific errors arising from invalid Criterion arguments?
    (3) Additional details. The note “This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)” is unnecessary and already covered by the reference in the ODF standard section.
    (4) Examples. The warning “In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text.” does not warrant the status of warning in my opinion. I would just include the statement as a normal paragraph.
    (5) Examples. Could we add some value (compared to the Help page) by including at least one example of using this function with a wildcard search? Note that wildcards are different from regular expressions.

    --Stevefanning (talk) 2020-10-05T15:31:30 (UTC)

    Ronnie

    • The Average_Range is an optional argument hence stating its dependence in general doesn't seem logical for the case when user opts out of it.
    • All other points addressed