Thankfully, Microsoft Excel's COUNTIF formula swoops in to save the day. It lets you count cells based on specific text or conditions, turning your spreadsheet chaos into organized data magic.

Because the functions you're about to use produce spilled arrays, and spilled arrays don't work in formatted Excel tables, you need to type the formulas in areas of your spreadsheet that are not ...