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 Calculate Count Customers By Region

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

Calculate Count customers by region with a ready-to-use formula for Excel, Google Sheets, and WPS.

Calculate Count customers by region.

ExcelGoogle SheetsWPS

=COUNTIFS(A:A, E2)

Count rows with a status with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows by category with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows by region with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows by month with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows with a flag with a ready-to-use formula for Excel, Google Sheets, and WPS.

Count rows by owner with a ready-to-use formula for Excel, Google Sheets, and WPS.