When you're staring at a massive spreadsheet, counting cells manually isn't just tedious—it's a recipe for mistakes. Thankfully, Microsoft Excel's COUNTIF formula swoops in to save the day.

If you have a spreadsheet where multiple cells contain the same text, you can quickly count them. Here are two ways to do it in Google Sheets that also work in Microsoft Excel. This guide comes ...