A
art
Hello:
I would like to add two amount by using the vlookup, however one might be
empty, which causes the vlookup to return #Value error. How can I check if
one cell is empty then dont add that cell.
Lets say : A B C D
1 John 600 Mark
2 Mark 550 Jones
3 Marry 650
4 Jones 645
And in cell A6 I should have the formula
=(vlookup(D1,EmpList,2)+Vlookup(D2,EmpList,2)+Vlookup(D3,EmpList,2)+Vlookup(D4,EmpList,2)
It should return the total amount and ignoring the cell that are empty.
Thanks.
Art
I would like to add two amount by using the vlookup, however one might be
empty, which causes the vlookup to return #Value error. How can I check if
one cell is empty then dont add that cell.
Lets say : A B C D
1 John 600 Mark
2 Mark 550 Jones
3 Marry 650
4 Jones 645
And in cell A6 I should have the formula
=(vlookup(D1,EmpList,2)+Vlookup(D2,EmpList,2)+Vlookup(D3,EmpList,2)+Vlookup(D4,EmpList,2)
It should return the total amount and ignoring the cell that are empty.
Thanks.
Art