Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

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

Paste the formula into the first output cell, then fill down to apply it to your range.

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

Sum values if text starts with LEAD- in crm export text.

ExcelGoogle SheetsWPS

=SUMIFS(B:B, A:A, "LEAD-*")

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

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

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

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

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

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