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 Count Rows If Text Ends With -Test In Imported Csv Text

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

Count rows when text ends with -TEST in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows if text ends with -TEST in imported csv text.

ExcelGoogle SheetsWPS

=COUNTIFS(A:A, "*-TEST")

Count rows when text ends with -US in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows when text ends with -EU in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows when text ends with -APAC in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows when text ends with -DEV in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows when text ends with -TEST in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows when text ends with -BETA in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.