Talk:Documentation/Calc Functions/AVERAGEIFS
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)