Count VLOOKUP #N/A

**rdirvngjr** · 03-15-2011, 04:19 PM

Is there a way to count/sum up the number of VLOOKUP #N/A returns?

**day92** · 03-15-2011, 04:23 PM

Yes you can sort by #N/A and then count from there.

**daddylonglegs** · 03-15-2011, 04:26 PM

This formula will count #N/A errors in column A

=COUNTIF(A:A,"#N/A")

**scottylad2** · 03-15-2011, 04:28 PM

if your Vlookup results are in A1:A12 try this
SUMPRODUCT(--(ISNA(A1:A12)))

**Ron Coderre** · 03-15-2011, 04:28 PM

If your VLOOKUP formulas are in A1:A10

this formula returns the count of cells that returned #N/A

Please Login or Register  to view this content.

Is that something you can work with?

**rdirvngjr** · 03-15-2011, 07:47 PM

Thanks all...
The "COUNTIF" solutions work great. Solved

Re: Count VLOOKUP #N/A