lookup values to sum
 

using vlookup i can select a value from a different worksheet, but can i
select a range of values to sum together?

If your lookup value appears multiple times, use SUMIF to
sum for each occurrence:

=VLOOKUP(A1,Sheet2!A:D,4,0)

becomes

=SUMIF(Sheet2!A:A,A1,Sheet2!D:D)

HTH
Jason
Atlanta, GA

-----Original Message-----
using vlookup i can select a value from a different
worksheet, but can i
select a range of values to sum together?
.

Not sure if this is what you're after but check out the SUMIF function in
help and if you'ld like more assistance please reply post with additional
details of your requirements.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"andysmith25" wrote in message
...
using vlookup i can select a value from a different worksheet, but can i
select a range of values to sum together?