Not yet... My solution would be:
row of data on sheet1 A2:I2

formula on sheet2 =SUM(Sheet1!A2:I2)

Mike F
"Bob Phillips" wrote in message
...
That might make sense to Mike, but it doesn't to me.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



wrote in message
...
On Apr 29, 11:55 am, "Mike Fogleman" wrote:
Why VLookup? Why not SUM. VLookup needs three arguments, where are they
located?

Mike wrote in message

...



Hi,

I have a row of 5 values. The sum of the 5 need to be put into another
worksheet using the VLOOKUP function. Does anyone know how to do this?

Thanks.- Hide quoted text -

- Show quoted text -

ah, because my manager doesn;t want the total (sum) to appear on the
first sheet, he only want it on the second sheet which is why I need a
formulae which will both do a SUM calculation and a VLOOKUP (if
necessary)