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