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 Unique Values By Status Active In Transaction Text

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

Count unique values for status Active in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count unique values by status Active in transaction text.

ExcelGoogle SheetsWPS

=COUNTA(UNIQUE(FILTER(B:B, A:A="Active")))

Count unique values for status Paid in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count unique values for status Pending in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count unique values for status Cancelled in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count unique values for status Refunded in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count unique values for status On Hold in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count unique values for status Paid in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.