Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the sum of vlookup?
I have 4 worksheet each with over 80 rows of information.
I want to lookup a code in one column, and if found I want the value from the immediately adjacent column pulled out and added up eg: code value a 1.00 b 2.00 a 5.03 c 0.45 d 1.20 a 2.50 so that if I looked up "a" in the first column, it would add 1.00, 5.03 and 2.50 from the second column and spit out a total for me. I want this to complete the same function on all 4 worksheets and get me the total value from all worksheets for each code. I've tried various function combinations of IF, VLOOKUP, SUM etc and can't seem to get anything to return a result other than error. please help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the sum of vlookup?
=SUMIF(A2:A7,"=a",B2:B7) Lookup SUMIF function in Help for more info on using this function. -- Regards, OssieMac "jiffy" wrote: I have 4 worksheet each with over 80 rows of information. I want to lookup a code in one column, and if found I want the value from the immediately adjacent column pulled out and added up eg: code value a 1.00 b 2.00 a 5.03 c 0.45 d 1.20 a 2.50 so that if I looked up "a" in the first column, it would add 1.00, 5.03 and 2.50 from the second column and spit out a total for me. I want this to complete the same function on all 4 worksheets and get me the total value from all worksheets for each code. I've tried various function combinations of IF, VLOOKUP, SUM etc and can't seem to get anything to return a result other than error. please help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the sum of vlookup?
You want Sumif, as in:
=Sumif(a:a,"a",b:b) Regards, Fred "jiffy" wrote in message ... I have 4 worksheet each with over 80 rows of information. I want to lookup a code in one column, and if found I want the value from the immediately adjacent column pulled out and added up eg: code value a 1.00 b 2.00 a 5.03 c 0.45 d 1.20 a 2.50 so that if I looked up "a" in the first column, it would add 1.00, 5.03 and 2.50 from the second column and spit out a total for me. I want this to complete the same function on all 4 worksheets and get me the total value from all worksheets for each code. I've tried various function combinations of IF, VLOOKUP, SUM etc and can't seem to get anything to return a result other than error. please help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the sum of vlookup?
Hi "jiffy"
=SUMIF(A:A,"a",B:B) will give you the sum for the current sheet For getting sum from multiple sheets try the below. Assuming your sheets are named Sheet1,Sheet2,Sheet3,Sheet4 etc; then =SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&ROW(INDIRECT(" 1:4"))&"'!A1:A100"),"a",INDIRECT("'Sheet"&ROW(INDI RECT("1:4"))&"'!B1:B100"))) If this post helps click Yes --------------- Jacob Skaria "jiffy" wrote: I have 4 worksheet each with over 80 rows of information. I want to lookup a code in one column, and if found I want the value from the immediately adjacent column pulled out and added up eg: code value a 1.00 b 2.00 a 5.03 c 0.45 d 1.20 a 2.50 so that if I looked up "a" in the first column, it would add 1.00, 5.03 and 2.50 from the second column and spit out a total for me. I want this to complete the same function on all 4 worksheets and get me the total value from all worksheets for each code. I've tried various function combinations of IF, VLOOKUP, SUM etc and can't seem to get anything to return a result other than error. please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |