How to count cells that contain specific value in Excel? - Excel Tips and Tricks

Discover how to count cell that contains specific value in Excel. Essentially, in excel count cells with specific text. You can also use the same technique in excel to count cells with text or numbers.

Excel is a powerful tool used for organizing, analyzing, and presenting data. One of the most basic and commonly used functions in Excel is the ability to count cells that meet certain criteria. This function is particularly useful when you need to analyze large datasets and want to quickly find the number of cells that contain a specific value. In this context, counting cells that contain a specific value in Excel can be incredibly helpful in streamlining workflows and improving productivity. In this article, we'll explore different methods to count cells that contain a specific value in Excel, which can be applied to a wide range of tasks and projects.

This is the formula featured in my video.

=COUNTIF(B2:B204,"Not Paid")

Note that the formula is case-insensitive by default, so it will count cells containing "Paid", "paid", "PAID", etc.
That is the following formula produces the same result.

=COUNTIF(B2:B204,"NoT PAId")
=COUNTIF(B2:B204,"Not PAID")
=COUNTIF(B2:B204,"NOT PAID")

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

[misterwill]

I’ve needed this more type of formula more than once. 😊 Could this formula be modified for a quantity like $0.00 or less than $100 instead of not paid?