Help w/multiple column criteria summary report

Paul Newcome

=IF(OR([1st Column]@row = "Yes - Defect Remediated", [1st Column]@row = "No - Fail"), 1) + IF(OR([2nd Column]@row = "Yes - Defect Remediated", [2nd Column]@row = "No - Fail"), 1) + ..............

Basically you are going to want to use this to populate a if true:

IF(OR([Column Name]@row = "Yes - Defect Remediated", [Column Name]@row = "No - Fail"), 1)

Then you are going to write a second one for the second column, a third one for the third column, so on and so forth. Then you can add them all together.

=IF(....., 1) + IF(....., 1) + IF(....., 1)

You would get a 1 for every column that is "true" and since you are linking together with the + all of those 1's will be added together for that row.

Once you establish that for each row, you can run your metrics on this formula column.