hi...

How we bring multiple columns from lookup table to single cell by adding all
the lookup values?

Ex:

I have sheet1 consisting the errors details of the all employees like this...

A1 A2 A3 A4 A5
1 emp Id 1st week 2nd week 3rd week 4th week
2 805033 3 0 1 4
3 805024 4 1 2 0
4 805036 4 1 0 1
5 805042 0 2 0 0
-------------------------------------------------------------------------------
in sheet2 I need to lookup each employee with total errors in a month i.e.
1st week+2nd week+3rd week....

so The result should lookup one employee errors by adding all errors.

the result should be like this for above example:

A1 A2
1 emp Id total errors
2 805033 8
3 805024 7
4 805036 6
5 805042 2

thanks in advance.