Excel's COUNT function produces a number of cells ... Say I was looking at a statement of paychecks over a wide date range, ...

You need to change the cell number to count the items of a different cell. Although this formula works smoothly in Excel and Google Sheets, there is a drawback. You need to change the cell number ...