Talk:Documentation/Calc Functions/AVERAGEIFS

    From The Document Foundation Wiki

    SF comment

    (1) Arguments. In the fourth paragraph, suggest change “Range1” to “Range 1”. Similarly, in fifth paragraph, change “Criterion1 to “Criterion 1”.
    (2) 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.
    (3) 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.
    (4) General. I think only one error condition is mentioned, i.e. Func_Range and Range1, Range2, etc not having the same size. Are there any other obvious error conditions?

    --Stevefanning (talk) 2020-10-05T15:56:03 (UTC)