Hi
I am looking for some help. I am looking to count the number of passed test cases per day which I currently use COUNTIFS formula.
=COUNTIFS(Runs!$I:$I,C2,Runs!$E:$E,"Passed") where 'Runs' is the data source tab and row 2 has the date value.
However my data source (contents of Runs tab) has changed where I have no control over column location of the 'Date' and (test case) 'Status' field will be located.
I am seeking help in providing an excel formula to solve my probelm.
The reason I am looking to solve this issue is that I was to create a standardaise graph reports for different people however I have no control over the specific location of the Execution Status column.
Many thanks
Jim
I am looking for some help. I am looking to count the number of passed test cases per day which I currently use COUNTIFS formula.
=COUNTIFS(Runs!$I:$I,C2,Runs!$E:$E,"Passed") where 'Runs' is the data source tab and row 2 has the date value.
However my data source (contents of Runs tab) has changed where I have no control over column location of the 'Date' and (test case) 'Status' field will be located.
I am seeking help in providing an excel formula to solve my probelm.
The reason I am looking to solve this issue is that I was to create a standardaise graph reports for different people however I have no control over the specific location of the Execution Status column.
Many thanks
Jim
