#### groovyjames

##### New Member

- Joined
- Mar 3, 2005

- Messages
- 3

i've got an excel file with descriptions in the first column and values spread out in multiple columns to the right:

A 10 20 30

B 5 12 39

C 98 32 12

i need a function which will search for a value in column A and return the sum of the values in columns B to D, ie for "a" the answer would be 60

i've tried using VLOOKUP(A:A;"A";B:B)+VLOOKUP(A:A;"A";C:C)+VLOOKUP(A:A;"A";C:C) but the formular is too long for excel when I increase the number of columns. i thought VLOOKUP(A:A;"A";B:D) could work, but it doesn't. does anyone know how I could solve this problem?

cheers, james