I have been trying to calculate the sum value from the column of one
worksheet to a cell in another worksheet (all in the same workbook). I have
tried the VLOOKUP function where I establish the look_up_value and compare it
to an array in the other worksheet. It works except that the value it returns
is the last cell in the array that meets the look up value. I want it to SUM
all the applicable cells in that column that meet the look up value.

Any suggestions would be greatly appreciated.

Thanks!

Have you looked at the SUMIF function?

e.g. =SUMIF(Sheet1!A2:A5,"g",Sheet1!B2:B5) will sum all values in range
B2:B5 on Sheet1 where the corresponding values in range A2:A5 are 'g'.

=SUMIF(A2:A100,H2,B2:B100)

where H2 is the criteria and B2:B100 is the range you want to sum where
A2:A100 equals H2


adapt to fit your own data accordingly

--


Regards,


Peo Sjoblom



"Bob Walters" <Bob wrote in message
...
I have been trying to calculate the sum value from the column of one
worksheet to a cell in another worksheet (all in the same workbook). I
have
tried the VLOOKUP function where I establish the look_up_value and compare
it
to an array in the other worksheet. It works except that the value it
returns
is the last cell in the array that meets the look up value. I want it to
SUM
all the applicable cells in that column that meet the look up value.

Any suggestions would be greatly appreciated.

Thanks!

Darren -

Perfect!! Thanks so much.

"Darren Bartrup" wrote:

Have you looked at the SUMIF function?

e.g. =SUMIF(Sheet1!A2:A5,"g",Sheet1!B2:B5) will sum all values in range
B2:B5 on Sheet1 where the corresponding values in range A2:A5 are 'g'.

No problem. Glad to help :)

"Bob Walters" wrote:

Darren -

Perfect!! Thanks so much.

"Darren Bartrup" wrote:

Have you looked at the SUMIF function?

e.g. =SUMIF(Sheet1!A2:A5,"g",Sheet1!B2:B5) will sum all values in range
B2:B5 on Sheet1 where the corresponding values in range A2:A5 are 'g'.