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 and C2 is date value.
However my data source 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.
Many thanks
Jim
Bookmarks