buddydubbo
New Member
- Joined
- Nov 1, 2011
- Messages
- 7
job | task | charge | codes | prices | ||
N34 | cable mod plate | 125 | cable | 40 | ||
N35 | cable socket mod | connect | 10 | |||
N38 | socket connect mod | plate | 15 | |||
N44 | cable plate socket | socket | 25 | |||
mod | 70 | |||||
<tbody>
</tbody>
hi i new to advance formulas and i need a formula to look at the code words in the task column
and to sum them as a total from the prices next to the codes in the charge column.
so C2 will look at B2 and check if any words from range E2:E6 appear and add the sum of there corresponding price in range F2:F6 .
many thanks in advance.