| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding column data based on match in 2nd column - Help
Hi,
Simple problem, but got me stumped. The setup: I have 2 columns. The first (column A starting in row 10) has members' names. The second (column B starting in row 10) has the additions made by the members over time. Column B has a 'header' cell that adds up the values entered by a particular member. The header cell for column B is B9. Cell A1 contains the member's name that cell B9 has to add the values for. I need a formula for Cell B9. For example: [Cell A1] Member A [Row 9] Formula needed for cell B9 COLUMN A_______|| COLUMN B____ [Row 10] Member A || Addition: 100 [Row 11] Member B || Addition: 50 [Row 12] Member C || Addition: 20 [Row 13] Member A || Addition: 100 [Row 14] Member C || Addition: 20 Result: If [Cell A1] = Member A then B9 = B10+B13 = 200 If [Cell A1] = Member B then B9 = B11 = 50 If [Cell A1] = Member C then B9 = B12+B14 = 40 I may have as many as 12 members, as in A10 to A22 Appreciate the help. GBExcel -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201001/1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding column data based on match in 2nd column - Help
Addition: 100
Does the cell actually contain the word Addition? See if this does what you want... =SUMIF(A10:A100,A1,B10:B100) -- Biff Microsoft Excel MVP "GBExcel via OfficeKB.com" <u55438@uwe wrote in message news:a2b25cedbcdca@uwe... Hi, Simple problem, but got me stumped. The setup: I have 2 columns. The first (column A starting in row 10) has members' names. The second (column B starting in row 10) has the additions made by the members over time. Column B has a 'header' cell that adds up the values entered by a particular member. The header cell for column B is B9. Cell A1 contains the member's name that cell B9 has to add the values for. I need a formula for Cell B9. For example: [Cell A1] Member A [Row 9] Formula needed for cell B9 COLUMN A_______|| COLUMN B____ [Row 10] Member A || Addition: 100 [Row 11] Member B || Addition: 50 [Row 12] Member C || Addition: 20 [Row 13] Member A || Addition: 100 [Row 14] Member C || Addition: 20 Result: If [Cell A1] = Member A then B9 = B10+B13 = 200 If [Cell A1] = Member B then B9 = B11 = 50 If [Cell A1] = Member C then B9 = B12+B14 = 40 I may have as many as 12 members, as in A10 to A22 Appreciate the help. GBExcel -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201001/1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding column data based on match in 2nd column - Help
No, just the number.
Thanks, your formula works perfectly. (I tried SUMIF but it didn't work. You must have the magic touch. ;-)) GBExcel T. Valko wrote: Addition: 100 Does the cell actually contain the word Addition? See if this does what you want... =SUMIF(A10:A100,A1,B10:B100) Hi, [quoted text clipped - 35 lines] GBExcel -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201001/1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding column data based on match in 2nd column - Help
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "GBExcel via OfficeKB.com" <u55438@uwe wrote in message news:a2b294a538742@uwe... No, just the number. Thanks, your formula works perfectly. (I tried SUMIF but it didn't work. You must have the magic touch. ;-)) GBExcel T. Valko wrote: Addition: 100 Does the cell actually contain the word Addition? See if this does what you want... =SUMIF(A10:A100,A1,B10:B100) Hi, [quoted text clipped - 35 lines] GBExcel -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201001/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding data in columns based on criteria in more than one column.. | Excel Worksheet Functions | |||
| Adding rows of data based on first column | New Users to Excel | |||
| Excel 2000: Adding column D based on value in column A | Excel Worksheet Functions | |||
| Adding a Custom Column based on an existing Column (EXPERT) | Excel Worksheet Functions | |||
| Adding total dollars based on specific data from another column | Excel Discussion (Misc queries) | |||
Linear Mode
