Find string and return corresponding cell value

[sankaricwai]

Hi,

Please suggest the formula for the below attachment.

Here, I want to add all the Positive Strings as gross deferred tax assets and all the Negatives strings as gross deferred tax liabilities expect valuation allowance.
The valuation allowance should be less from the gross deferred tax assets and will not add to the Liabilities.

Hence I need the formula for the below presentation

Gross deferred tax assets ******* (all positive figures)
less: valuation allowance ******* (if the string matches "Tion Allow", it should be deduct from the tax assets)
Gross deferred tax liabilites *******(all negative figures)

Please send the formula for the below case.

Thank you,

T. Uma Sankar.