| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sum if another column matches
I have a column A of numbers with a corresponding 2nd column B of amounts. If
the number in a cell of column A matches the number any another cells in column A, I want to add the corresponding amount from column B into the cell in column C. e.g.: A B C 1 88 10 50 2 63 30 230 3 88 40 50 4 23 100 100 5 63 200 230 Stated differently: - If there are no matches in column A, then the cell in column C gets just the value from column B. - If there are matching entries in column A, then I want all of the corresponding values from column B summed into the cell in column C. Am I making any sense? Thanks! -- sdm |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sum if another column matches
On Thu, 31 Jul 2008 15:09:01 -0700, sdm
wrote: I have a column A of numbers with a corresponding 2nd column B of amounts. If the number in a cell of column A matches the number any another cells in column A, I want to add the corresponding amount from column B into the cell in column C. e.g.: A B C 1 88 10 50 2 63 30 230 3 88 40 50 4 23 100 100 5 63 200 230 Stated differently: - If there are no matches in column A, then the cell in column C gets just the value from column B. - If there are matching entries in column A, then I want all of the corresponding values from column B summed into the cell in column C. Am I making any sense? Thanks! Try this formula in cell C1 =SUMPRODUCT((A$1:A$10=A1)*(B$1:B$10)) Copy down as far as needed Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sum if another column matches
=SUMIF(A:A,A1,B:B)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "sdm" wrote in message ... I have a column A of numbers with a corresponding 2nd column B of amounts. If the number in a cell of column A matches the number any another cells in column A, I want to add the corresponding amount from column B into the cell in column C. e.g.: A B C 1 88 10 50 2 63 30 230 3 88 40 50 4 23 100 100 5 63 200 230 Stated differently: - If there are no matches in column A, then the cell in column C gets just the value from column B. - If there are matching entries in column A, then I want all of the corresponding values from column B summed into the cell in column C. Am I making any sense? Thanks! -- sdm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Display list from one colum if value in other column matches x | Excel Discussion (Misc queries) | |||
| Comparing 2 column for matches | Excel Discussion (Misc queries) | |||
| data that matches exact column and row | Excel Worksheet Functions | |||
| Using VLOOKUP with multiple first column matches | Excel Worksheet Functions | |||
Linear Mode
