SUM a row of data and then use VLOOKUP to paste the total value intoanother worksheet
 

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.

SUM a row of data and then use VLOOKUP to paste the total value into another worksheet
 

Why do you need VLOOKUP, SUM would place the value quite nicely on it's own.

--
---
HTH

Bob


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



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.

SUM a row of data and then use VLOOKUP to paste the total value into another worksheet
 

Why VLookup? Why not SUM. VLookup needs three arguments, where are they
located?

Mike F
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.

SUM a row of data and then use VLOOKUP to paste the total valueinto another worksheet
 

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)

SUM a row of data and then use VLOOKUP to paste the total value into another worksheet
 

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)

SUM a row of data and then use VLOOKUP to paste the total value into another worksheet
 

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)