New Member - Formula Help

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.