For the moment, you are interested only in quantities greater than 1 and you filtered your table accordingly. To make the examples easier to follow, let's take a quick look at the source data first.Īssuming, you have a table with Order IDs in column B and Quantity in column C like shown in the image below. To count visible items in a filtered list, you will need to use a combination of 4 or more functions depending on whether you want an exact or partial match.
How to count filtered cells with specific text =SUMPRODUCT(-(ISNUMBER(FIND(D1, A2:A10))))Īnd this returns a count of 3 (cells A2, A3 and A6): To test the formula on real-life data, let's find how many cells in A2:A10 contain the substring input in D1: