Excel's COUNTIF and COUNTIFS functions are exactly ... Say I was looking at a statement of paychecks over a wide date range, ...

Excel's logical functions test whether a statement or data is true or false ... such as INDEX with MATCH, and COUNTIF with SUM. If you're not familiar with these, it's certainly worth giving ...