Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup One Column - Sum Another
I have a spreadsheet that contains text in one column and then dollar amounts in the other. I am looking for a way to search the text and sum all the dollar amounts that equal the text. Example: COLUMN A[/b] [b]COLUMN B $1,500.00 CD $1,000.00 CD $5,000.00 CD $7,724.40 CL $2,000.00 CL $2,183.08 CL I am looking for a formula that will search for CD (located in column B) and sum all the amounts (located in column A), search for CL (located in column B) and sum all those amounts (located in Column A) and so on. So in this example, CD=$7,500.00 and CL=$11,907.48 Thank you in advance for the help! Paul -- pw034 ------------------------------------------------------------------------ pw034's Profile: http://www.excelforum.com/member.php...fo&userid=7091 View this thread: http://www.excelforum.com/showthread...hreadid=496570 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup One Column - Sum Another
=SUMIF(B:B,"CD",A:A)
do the same for CL or replace both by a cell reference where you can type in the criteria e.g. =SUMIF(B:B,E1,A:A) -- Regards, Peo Sjoblom (No private emails please) "pw034" wrote in message ... I have a spreadsheet that contains text in one column and then dollar amounts in the other. I am looking for a way to search the text and sum all the dollar amounts that equal the text. Example: COLUMN A[/b] [b]COLUMN B $1,500.00 CD $1,000.00 CD $5,000.00 CD $7,724.40 CL $2,000.00 CL $2,183.08 CL I am looking for a formula that will search for CD (located in column B) and sum all the amounts (located in column A), search for CL (located in column B) and sum all those amounts (located in Column A) and so on. So in this example, CD=$7,500.00 and CL=$11,907.48 Thank you in advance for the help! Paul -- pw034 ------------------------------------------------------------------------ pw034's Profile: http://www.excelforum.com/member.php...fo&userid=7091 View this thread: http://www.excelforum.com/showthread...hreadid=496570 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup One Column - Sum Another
That did it! Than you so much :) -- pw034 ------------------------------------------------------------------------ pw034's Profile: http://www.excelforum.com/member.php...fo&userid=7091 View this thread: http://www.excelforum.com/showthread...hreadid=496570 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
2 Column Data lookup | Excel Discussion (Misc queries) | |||
Column Lookup | Excel Discussion (Misc queries) | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
How to lookup data in a row and column | Excel Discussion (Misc queries) |