Value error on addition

[bucci35]

I have the following formula in numerous cells

=IF('Data by store'!$F$2="","",VLOOKUP(B4&D4,'Data by store'!$A$7:$K$1000,'Data by store'!$F$2,0))

When I try to sum these up when their is no value in them, I get a value error in the cell I am using to sum them in.

Any ideas

 

[Smitty]

Try using 0 instead of "".

HTH,

Smitty

 

[Scott Huish]

Return a 0 instead of ""

and format the cell as:
[=0]""

although SUM should ignore the ""