How to use ISERROR

[any]

I have the following Vlookup results in excel

Birth date Name Sex FINAL #
#N/A #N/A #N/A 0
2 #N/A #N/A 2
#N/A #N/A 3 3

From the above how to set a formula in FINAL # with
ISERROR if all the 3 the results are #N/A then 0 else just
pick 2 and 3 repesctively.

Kindly help.

 

[Aladin Akyurek]

Since you seem to expect a single number or no number at all...

=SUMIF(A2:C2,"<>#N/A")

 

[Guest]

Hi

But I still can't get the 2nd row for 2 and 3rd row for 3.

Kindly help again.

 

[Aladin Akyurek]

The formula

=SUMIF(A2:C2,"<>#N/A")

assumes the data to be in row 2 from A2 to C3 (the rwo with three #N/A's.

You enter the formula in D2 and drag it down to D3 and D4.
..