Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum results based on a reference
I have column A with several repeating references (e.g: 1, 2, 3,4,3,2,4,5,2,
etc), I need to be able to sum the values in column B that match the specific reference. e.g.: A B 1 25 2 14 3 18 1 20 3 25 Therefore, if I am looking at sum of all values referred from "1", my total is 45 (25+20). Can someone help? my columns A and B can go to hundreds of rows, and no more than 30 to 50 references. thank you, Mauro |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum results based on a reference
In C1, enter this formula and drag it down. HTH Otto
=SUMIF($A$1:$A$5,A1,$B$1:$B$5) "Mauro" wrote in message ... I have column A with several repeating references (e.g: 1, 2, 3,4,3,2,4,5,2, etc), I need to be able to sum the values in column B that match the specific reference. e.g.: A B 1 25 2 14 3 18 1 20 3 25 Therefore, if I am looking at sum of all values referred from "1", my total is 45 (25+20). Can someone help? my columns A and B can go to hundreds of rows, and no more than 30 to 50 references. thank you, Mauro |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum results based on a reference
Hi,
Create a pivot table. Drag column A to the row area and column B to the data area -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mauro" wrote in message ... I have column A with several repeating references (e.g: 1, 2, 3,4,3,2,4,5,2, etc), I need to be able to sum the values in column B that match the specific reference. e.g.: A B 1 25 2 14 3 18 1 20 3 25 Therefore, if I am looking at sum of all values referred from "1", my total is 45 (25+20). Can someone help? my columns A and B can go to hundreds of rows, and no more than 30 to 50 references. thank you, Mauro |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum results based on a reference
Thank you Otto, it worked beautifully!
"Mauro" wrote: I have column A with several repeating references (e.g: 1, 2, 3,4,3,2,4,5,2, etc), I need to be able to sum the values in column B that match the specific reference. e.g.: A B 1 25 2 14 3 18 1 20 3 25 Therefore, if I am looking at sum of all values referred from "1", my total is 45 (25+20). Can someone help? my columns A and B can go to hundreds of rows, and no more than 30 to 50 references. thank you, Mauro |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum results based on a reference
Glad to help. Thanks for the feedback. Otto
"Mauro" wrote in message ... Thank you Otto, it worked beautifully! "Mauro" wrote: I have column A with several repeating references (e.g: 1, 2, 3,4,3,2,4,5,2, etc), I need to be able to sum the values in column B that match the specific reference. e.g.: A B 1 25 2 14 3 18 1 20 3 25 Therefore, if I am looking at sum of all values referred from "1", my total is 45 (25+20). Can someone help? my columns A and B can go to hundreds of rows, and no more than 30 to 50 references. thank you, Mauro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning a Value based on Results | Excel Worksheet Functions | |||
HOW DO I REFERENCE A CELL FROM THE RESULTS OF TWO WORKSHEETS | Excel Discussion (Misc queries) | |||
HOW DO I REFERENCE A CELL FROM THE RESULTS OF TWO WORKSHEETS | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |