If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|