Adding onto an existing formula

[zone709]

=IFERROR(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,10,0),"")

=IFERROR(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,10,0),"")+IFERROR(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,8,0),"")


I also tried this but cant get it to go +(VLOOKUP(@$H$3:$H$693, 'Pay (2)'!$D$2:$P$398,8,0),"")

 

[RoryA]

If one or both parts returns "" you can't add it to anything, so you'd get an error.

 

[zone709]

So your saying i cant used this formula? I am just trying to add the range also from ,8

 

[RoryA]

If you're trying to add numbers, your IFERROR should return 0, not "", for errors.