| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? . |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to lookup multiple values and summing them up in one cell | Excel Worksheet Functions | |||
| Multiple lookup value's | Excel Worksheet Functions | |||
| Need help with lookup and comparing values | Excel Worksheet Functions | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
| LOOKUP FUNCTION WITH SUMS VALUES | Excel Discussion (Misc queries) | |||
Hybrid Mode
