Find text in a column and calculate numbers in the same row

Hi

New to this forum and i really need some help

I want to find all cells in column 1 containing a specific word and do a calculation with the numbers after the cells.

For example...

A B C D E
1 sol 34 4
2 bord 12 2
3 stol 4 2
4 bord 5 1
5 leka 8 5
6 gata 14 9
7 sol 15 4

I have a list of 50 words that i want to find in column A. Then I want to use the numbers in that row and do a calculation.


"sol" 34 - 4 = 30
"sol" 15 - 4 = 11

D1 = sol
E1 = 41 (adding the results of the calculation from the word "sol"



"bord" 12 - 2 = 10
"bord" 5 - 1 = 4

D2 = bord
E2 = 14



D3 = stol
E3 = 2

D4 = leka
E4 = 3

D5 = gata
E5 = 5


Is this possible?

Thanks

Fabian

easier to look at the workbook this way...Workbook2.xlsx

I added the result i´m after

Workbook2.xlsx

Cool. It actually works I got the calculation right.

Is there a way to show which word is linked to which result?

Sorry. I got it right now

But...I forgot something. The A column contains other letters than just the word i want to identify from the E column.

A cell in the A column could look like this: /hus/husmodeller/sol

...so if the cell contains "sol" it should count.

Shall i make a workbook to make it easier to explain?


Thanks for helping me!

/Fabian

Workbook3.xlsx

Ok, I´ll do it with the actual data.

I want to find the cells in column A containing the word in column E and do the calculation. B minus C

For exampel cell E4 is "soderhill" and in the A column you can find "soderhill" in cell A4 and A10. So in the cell F4, next to "soderhill", i want the result of the calculation.

1010(B4) - 73(C4) = 937
837(B10) - 35(C10) = 802
937 + 802 = 1739

F4 = 1739


/Fabian

OMG. So cool!


Thank you so much


/Fabian