I have a reference chart (first picture) that has many columns with many rows of information i have created a formula to read the chart and output an answer based on what it reads, but after further review I need the output to have one more stipulation.
Here is my current code for the whole process:
=IF(COUNTIFS('ESU1'!A3:A50,"*DIRECT*",'ESU1'!B3:B50,"*CONSOLIDATION*",'ESU1'!C3:C50,">="&DATE(2011,10,1)),"On or After 10/01/2011",IF(COUNTIFS('ESU1'!A3:A50,"*DIRECT*",'ESU1'!B3:B50,"*CONSOLIDATION*",'ESU1'!C3:C50,"<"&DATE(2011,10,1)),"Before 10/01/2011","Needs to be Done"))
Here is the code that needs the added stipulation:
COUNTIFS('ESU1'!A3:A50,"*DIRECT*",'ESU1'!B3:B50,"*CONSOLIDATION*",'ESU1'!C3:C50,">="&DATE(2011,10,1)),"On or After 10/01/2011", {help write the code for this stipulation listed below}
I want to verify that Column A = Direct, Column B = Consolidation, Column C = Date >= 10/01/11, ADD "Countif Statement" Column H = only the lines which meet A, B, C Criteria have a number larger than zero in them
Loan Chart Reference_Excel Help.JPGOutput Chart_Excel Help.JPG
Bookmarks