Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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