I have a table in excel which contains a list of tests I run. These tests are part of an overall Run and there are 3 columns (Pass, Total, Percentage) that I add. I add these for each new run. The percentage column is the important one for me. I have 2 columns at the end of the table to count the number of tests that passed and failed for each row. If the % is 100% its marked as a pass. Anything less is a fail. See my attached file for an example of the table:
sample excel.xlsx
My question; is there any formula I can use which would automatically count the results for the columns 'Number of Tests Passed' and 'Number of Tests Failed'?
Let me know if I need to explain the table any further!
Thanks!
Bookmarks