Multiple conditions formula

[freddie_1]

I'd appreciate if someone can help me solve this formula.

I have a table as follows and am trying to find a formula to give me the results as in the final column.

It must satisfy the following conditions:

If Column A = balance AND column B is like *MARS* then value = Column E
If Column A = balance AND column B is not like *MARS* then value = 0
Anything else = Column C + Column D + Column E

balance	Withdrawal			-500	0
balance	Transfer			1000	0
balance	MARS:CASH:12345678			400	400
Credit	ABC	10	10	10	30
Debit	XYZ	20	20	20	60

 

[Eric W]

Try:

=IF(A1="balance",IF(COUNTIF(B1,"*mars*"),E1,0),C1+D1+E1)

 

[freddie_1]

You Sir are awesome....thank you very much.