A
andysmith25
using vlookup i can select a value from a different worksheet, but can i
select a range of values to sum together?
select a range of values to sum together?
J
Jason Morin
If your lookup value appears multiple times, use SUMIF to
sum for each occurrence:
=VLOOKUP(A1,Sheet2!A
,4,0)
becomes
=SUMIF(Sheet2!A:A,A1,Sheet2!D)
HTH
Jason
Atlanta, GA
sum for each occurrence:
=VLOOKUP(A1,Sheet2!A
,4,0)becomes
=SUMIF(Sheet2!A:A,A1,Sheet2!D
)HTH
Jason
Atlanta, GA
J
JulieD
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.
help and if you'ld like more assistance please reply post with additional
details of your requirements.