公式库

Excel Formula To Sum Values If Text Starts With Ord- In Transaction Text

Sum values when text starts with ORD- in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Sum values if text starts with ORD- in transaction text.

统一公式

ExcelGoogle SheetsWPS
=SUMIFS(B:B, A:A, "ORD-*")

使用说明

需要定制版本？

相关公式

Excel Formula To Sum Values If Text Starts With Id- In Transaction Text

Sum values when text starts with ID- in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values If Text Starts With Sku- In Transaction Text

Sum values when text starts with SKU- in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values If Text Starts With Inv- In Transaction Text

Sum values when text starts with INV- in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values If Text Starts With Cus- In Transaction Text

Sum values when text starts with CUS- in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values If Text Starts With Lead- In Transaction Text

Sum values when text starts with LEAD- in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values If Text Starts With Ref- In Transaction Text

Sum values when text starts with REF- in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.