Here's a quick and dirty formula you can use in Google Sheets to get a running count of cells that contain any value (numbers, dates, text, links, etc.).

If you want to count blank or empty cells in Excel and Google Sheets, here are the exact formulas you need to use.

This function is handy when you need to count cells that exceed (or fall under) a specified number. In the above image, an Excel sheet breaks down the payroll for two separate pay weeks.

Q. When I’m working in Excel, I sometimes have trouble remembering a formula. Is there an instant crib sheet I can refer to? I know I can look it up in Help , but that’s such a slow process. A. Yes, ...