Not-Your-Basic Counting
Excel’s COUNTIFS function enables users to count the number of cells that meet a certain criteria. (If you’re wondering why that’s valuable, then sit down to count manually the number of cells, in a 2,000-row spreadsheet, that contain the same word.)
If you handle large datasets, this function could save you oodles of time. Kevin Stratvert can show you how to use it.