SUM

[Guest]

hello,
i have some problem which i mentioned is as under:

A1 B1(this cell has vlookup formula) C1(result)
1000 900 =SUM(A1-B1)

#VALUE! error is coming out if B1 is empty otherwise is ok.

thanks in advance.

 

[Guest]

=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(....)

This puts a 0 in place of a blank or #N/A error. Then your sum will work
correctly.

Dave

 

[Guest]

Try:

=(IF(ISNUMBER(B1),A1-B1,A1))

 

[T. Valko]

Try this:

=IF(COUNT(A1:B1)<2,"",A1-B1)

Biff

 

[Guest]

thank you very much it's working.

Try:

=(IF(ISNUMBER(B1),A1-B1,A1))

 

[Guest]

thank you very much it's working too.

Try this:

=IF(COUNT(A1:B1)<2,"",A1-B1)

Biff

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

thank you very much it's working too.