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.

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com