COUNTIF to find how many VLOOKUP finds

Don't miss that you can use Excel's COUNTIF formula to find how many entries in a given range of cells do not match a given value. So, in this example we have used VLOOKUP to find where the values in column A appear in column F.

COUNTIF can be used to find how many values were found that match the inventory in column F by entering the criteria "#N/A" preceded by '<>' to indicate the search is for anything other than this given value. So, the formula:

=COUNTIF(B2:B20,"<>#N/A")

. . . adds up the 9 occurrences of Apple and Pear in column B.