lookup values to sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
Adding up total hours worked on employee schedule using various criteria 0
Vlookup array formula problem 2
sun results of a vlookup across a range 3
Why can't I sum several vlookups ?? 5
Scrabble Value calculation for Welsh words 0
Using SUM & VLOOKUP together?? 1
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top