New Member - Formula Help

[Eddy_the_Surveyor]

Hi Community,

I have just signed up with a view to expanding my excel knowledge. For the last few days, I have been searching for a formula to help me, but have not found it, so I am turning to the Excel Guru Community. Thanks in advance for all help.

Scenario:

I have 4 columns on a spreadsheet (E to H). Based on the specific text in Columns E and G, I want to return certain values. Ideally, column H would total also.

For example:

If E4 is Not App. and G4 is Issued, H4 = 150

If E4 is Complete and G4 is Issued, H4 = 318

If E4 is Issued and G4 is Not App., H4 = 168

Is there a formula I can use for this and then fill down for the rows below?

I have attached a simple version showing the scenarios. Any help would be greatly appreciated, as this is now frustrating me greatly.

Thanks.

[#2]

@Eddy_the_Surveyor 

You defined the logic only for 3 combinations

What formula shall return for other ones?

[#3]

@Sergei Baklan 

Thanks for your reply. See below:

With Thanks,

[#4 · Accepted solution]

@Eddy_the_Surveyor Please see attached. Is that what you had in mind?

[#5]

@Riny_van_Eekelen 

That's Brilliant. Thank you.

Best Regards,

Eddy

[#6]

@Eddy_the_Surveyor This is better, I believe. Have removed the hard-code 150, 168 and 368. Used links to the numbers above the table in stead.