The COUNTIF function counts the number of times a condition is met. For example, if you have a list of days in a month in column A (cells A1:A31) and your sales receipts for those days in column B, you can count the number of days that your sales exceeded $5,000 with this function: =COUNTIF(B1:B31,">5000"). A similar function, SUMIF, totals values instead of counting them.

Get Our Best Stories!

This newsletter may contain advertising, deals, or affiliate links. Subscribing to a newsletter indicates your consent to our Terms of Use and Privacy Policy. You may unsubscribe from the newsletters at any time.