Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to add cells with same group
I have a sheet 1 with two columns. Column A has a manufacturer name, Column
B has a number. Column A has the manufacturer names repeated multiple times within the column. Sheet 2, Coumn A, I have a clean list of manfufacturers that match the cells in Sheet1 Column A. In sheet 2, Coulmn B, I need a formula that will add all the numbers for each manufacturer. So, if Hp shows up 15 times in column A, the formula will add only those numbers that match column A and produce the total of the numbers added together for that manufacturer. Ex. Sheet 1: Column A, Column B HP, 5.50 HP, 5.75 DF, 5.00 DF, 4.25 Sheet 2: end result Im looking for: HP, 11.25 DF, 9.25 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to add cells with same group
brantty wrote:
I have a sheet 1 with two columns. Column A has a manufacturer name, Column B has a number. Column A has the manufacturer names repeated multiple times within the column. Sheet 2, Coumn A, I have a clean list of manfufacturers that match the cells in Sheet1 Column A. In sheet 2, Coulmn B, I need a formula that will add all the numbers for each manufacturer. So, if Hp shows up 15 times in column A, the formula will add only those numbers that match column A and produce the total of the numbers added together for that manufacturer. Ex. Sheet 1: Column A, Column B HP, 5.50 HP, 5.75 DF, 5.00 DF, 4.25 Sheet 2: end result Im looking for: HP, 11.25 DF, 9.25 SUMIF is your friend here. Per help SUMIF "Adds the cells specified by a given criteria." In Sheet2 B1 and fill down: =SUMIF(Sheet1!A:A,A1,Sheet1!B:B) where Sheet2 A1 = HP A2 = DF etc. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to add cells with same group
"smartin" wrote: brantty wrote: I have a sheet 1 with two columns. Column A has a manufacturer name, Column B has a number. Column A has the manufacturer names repeated multiple times within the column. Sheet 2, Coumn A, I have a clean list of manfufacturers that match the cells in Sheet1 Column A. In sheet 2, Coulmn B, I need a formula that will add all the numbers for each manufacturer. So, if Hp shows up 15 times in column A, the formula will add only those numbers that match column A and produce the total of the numbers added together for that manufacturer. Ex. Sheet 1: Column A, Column B HP, 5.50 HP, 5.75 DF, 5.00 DF, 4.25 Sheet 2: end result Im looking for: HP, 11.25 DF, 9.25 SUMIF is your friend here. Per help SUMIF "Adds the cells specified by a given criteria." In Sheet2 B1 and fill down: =SUMIF(Sheet1!A:A,A1,Sheet1!B:B) where Sheet2 A1 = HP A2 = DF etc. Nice work. It worked and you taught me something new. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding 1 formula result in a group of cells | New Users to Excel | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
How can I use the COUNTIF formula on a group of specific cells? | Excel Discussion (Misc queries) | |||
how to change a formula for a large group of cells | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |