Help needed for Calculating Defect count and

[ashwithonline]

Hi All,

Needed your help in calculating defect count and defect Impact

Defect count (Column M) - Basis the number of defects in column N and Defect Status (which should not be closed). Each cell will have only one defect and if there are more than one row for each scenario. Defect will be only for scenarios with Fail status. If there are multiple defects with some of them closed, then in that case only the non closed should be considered.

Defect Impact (Column Q) - Basis the defect count in the above question and Business Priority (Column P) and the reference table in Matrix worksheet.

Thanks for the help..!!!

 

[ashwithonline]

Hi All,

Tried something on my own and was able to come up with a partial formula, but its not calculating for defect count more than 2 from the matrix sheet as reflected in the row 7...

can anybody pls help me here....