I am going to first address the questions asked in the first post. The following formula will display an 'X' in E1 when 'zx' is in C1 and a value greater than two is in D1. It will also display an 'X' in E1 when 'xc' is in C1 and a value greater than four is in D1. However as stated in post #4, it will not display an 'X' in E1 when 'xc' is in C1 and a value of three is in D1.
Formula:
=IF(AND(COUNTIFS(A:A,C1),D1>2),"X",IF(AND(COUNTIFS(B:B,C1),D1>4),"X",""))
In posts #4 and #5 cell J2 and "SLA Exceeded" were introduced. If I understand them correctly the formula could be modified to read:
Formula:
=IF(AND(COUNTIFS(A:A,C1),J2>2),"X",IF(AND(COUNTIFS(B:B,C1),J2>4),"SLA Exceeded",""))
Let us know if you have any questions.
Bookmarks