Revision history [back]

According to the SUMIFS help page, the criteria is an expression containing text or a regular expression.

=SUMIFS(B2:B5;A2:A5;".*Transport.*|.*Courier.*")


According to the SUMIFS help page, the criteria criterion is an expression containing text or a regular expression.

=SUMIFS(B2:B5;A2:A5;".*Transport.*|.*Courier.*")


Breakdown:

• B2:B5 is the example sum range
• A2:A5 is the example criterion range
• .* means match anything zero or more times
• | means match the first or the second expression

According to The criterion can be a regular expression, as explained in the SUMIFS SUMIF help page, the criterion is an expression containing text or a regular expression..

=SUMIFS(B2:B5;A2:A5;".*Transport.*|.*Courier.*")
=SUMIF(A2:A5;".*Transport.*|.*Courier.*";B2:B5)


Breakdown:

• B2:B5 is the example sum range
• A2:A5 is the example criterion range
• .* means match anything zero or more times
• | means match the first or the second expression
• B2:B5 is the example sum range

The criterion can be a regular expression, as explained in the SUMIF help page.. There is no need for arrays or two functions.

=SUMIF(A2:A5;".*Transport.*|.*Courier.*";B2:B5)


Breakdown:

• A2:A5 is the example criterion range
• .* means match anything zero or more times
• | means match the first or the second expression
• B2:B5 is the example sum range

The criterion can be a regular expression, as explained in the SUMIF help page. There is no need for arrays or two functions.

=SUMIF(A2:A5;".*Transport.*|.*Courier.*";B2:B5)


Breakdown:

• A2:A5 is the example criterion range
• .* means match anything zero or more times
• | means match the first or the second expression
• B2:B5 is the example sum range

The criterion can be a regular expression, as explained in the SUMIF help page. There is no need for arrays or two functions.

=SUMIF(A2:A5;".*Transport.*|.*Courier.*";B2:B5)


Breakdown:

• A2:A5 is the criterion range
• .* means match anything any character zero or more times
• | means match the first or the second expression
• B2:B5 is the sum range