masterschef
New Member
- Joined
- Jan 9, 2018
- Messages
- 3
[FONT=Arial, Helvetica Neue, Helvetica, sans-serif]Hi all,[/FONT]
[FONT=Arial, Helvetica Neue, Helvetica, sans-serif]I'm trying to build (what I thought to be a simple) Excel formula that matches a line item from one sheet with another line item from a second sheet and sums up all values in that matched row.[/FONT]
[FONT=Arial, Helvetica Neue, Helvetica, sans-serif]This formula needs to be flexible to accommodate new columns so I was hoping to use a mix of SUMIF and INDEX/MATCH.
[/FONT]
<tbody>
</tbody>
Please help!
<tbody>
</tbody>
[FONT=Arial, Helvetica Neue, Helvetica, sans-serif]I'm trying to build (what I thought to be a simple) Excel formula that matches a line item from one sheet with another line item from a second sheet and sums up all values in that matched row.[/FONT]
[FONT=Arial, Helvetica Neue, Helvetica, sans-serif]This formula needs to be flexible to accommodate new columns so I was hoping to use a mix of SUMIF and INDEX/MATCH.
[/FONT]
SHEET 1 | |||||||||
LINE ITEM | |||||||||
A | Summed value from sheet 2 | ||||||||
B | Summed value from sheet 2 | ||||||||
C | Summed value from sheet 2 | ||||||||
D | Summed value from sheet 2 | ||||||||
SHEET 2 | |||||||||
Line Item | Value 1 | Value 2 | Value 3 | Value 4 | |||||
A | 423 | 423 | |||||||
B | 423 | ||||||||
C | 234 | 324 | 423 | 23423 | |||||
D | 23423 | ||||||||
<tbody>
</tbody>
Please help!
Summed value from sheet 2 |
<tbody>
</tbody>