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
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