How to quickly count multiple things at once in Excel with COUNTIFS
Use this function to count items based on criteria. The example given only shows using one criterion (shirt size), but you can add multiple criteria to this function as well. This function also works in Google Sheets.