ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUM (https://www.excelbanter.com/excel-discussion-misc-queries/135773-sum.html)

Tufail

SUM

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.

Dave F

SUM

=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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"Tufail" wrote:

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.

Toppers

SUM

Try:

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

"Tufail" wrote:

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.

T. Valko

SUM

Try this:

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

Biff

"Tufail" wrote in message
...
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.

Tufail

SUM

thank you very much it's working.

"Toppers" wrote:

Try:

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

"Tufail" wrote:

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.

Tufail

SUM

thank you very much it's working too.

"T. Valko" wrote:

Try this:

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

Biff

"Tufail" wrote in message
...
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.

T. Valko

SUM

You're welcome. Thanks for the feedback!

Biff

"Tufail" wrote in message
...
thank you very much it's working too.

"T. Valko" wrote:

Try this:

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

Biff

"Tufail" wrote in message
...
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.

All times are GMT +1. The time now is 10:34 PM.