Hi Excel Forum Team,

I need help on an equation that will provide a total count for everything in a VLookup Iv'e done, but does not count the #N/A that VLookup provides when it doesn't pick up a match and other blank cells below the VLookup table.

Example:
-> Cell 1A is where the total cell count equation is.
-> Cell 2A thru. 11A is where the VLookup results are.
-> So, if the VLookup results come up with 8 matching results (ex.: John, Mark, Linda, etc.) in cells 2A thru. 9A and 2 non-matching results providing a #N/A in both 10A & 11A cells and the remaining blank cells below in 12A thru. infinity; the cell counter equation (in cell 1A) would only show a total of 8.

Thank you for reviewing my request for help!

Garrett