How do I use the Excel Formula To Total Rows By Category formula?

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

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

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

Total rows by category.

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.