Apr 03 2020 03:04 AM
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.
Apr 03 2020 03:36 AM
You defined the logic only for 3 combinations
What formula shall return for other ones?
Apr 03 2020 03:50 AM
Apr 03 2020 03:59 AM
Solution@Eddy_the_Surveyor Please see attached. Is that what you had in mind?
Apr 03 2020 04:04 AM
Apr 03 2020 04:06 AM
@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.
Apr 03 2020 03:59 AM
Solution@Eddy_the_Surveyor Please see attached. Is that what you had in mind?