How to use ISERROR

  • Thread starter Thread starter any
  • Start date Start date
A

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.
 
Since you seem to expect a single number or no number at all...

=SUMIF(A2:C2,"<>#N/A")
 
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.
..
 
Back
Top