SUMIFS 函数

返回多个区域中满足多个条件的区域中的单元格值之和。

This function is available since Collabora Office 4.0.

语法

SUMIFS(Func_Range; Range1; Criterion1[; Range2; Criterion2][; … ; [Range127; Criterion127]])

函数范围 – 必填参数。它是一个单元格区域、命名区域的名称或列/行标签, 包含用于计算总和的值。

Range1 – required argument. It is a range of cells, a name of a named range, or a label of a column or a row, to which the corresponding criterion is to be applied.

条件1 – 必填参数。表示逻辑条件的字符串表达式，或对此类字符串表达式的单元格引用。表达式可以包含文本、数字、正则表达式或通配符 (如果在计算选项中启用)。

范围2 – 可选。「范围2」和以下所有内容的含义与「区域1」相同。

条件2 – 可选。「条件2」和以下所有内容的含义与「条件1」相同。

The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in - Collabora Office Calc - Calculate.

When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0".

「Func_Range」和「区域1, 区域2...」必须具有相同的大小, 否则该函数返回错误: 502 - 无效的参数。