Formula to add amounts based on cell above

[Mldeuser]

Hello

I am looking for a formula that will look in column E for stx if found it will look at the cell above for the word sundry if found it will add the amount in column I for the stx row.

Cell E2 = stx
Cell E1 = sundry
Then add cell I2

I then need another formula that would look in column E for the word sundry if found it would look at the cell below for the word stx if none is found it would add the amount in column I

Thank you

 

[Mldeuser]

Hello

I created a work around for what I needed

Thank you

 

[smozgur]

Hello

I created a work around for what I needed

Thank you

Good to hear that you created a workaround.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.