Problems with IF, COUNTIF, arguments, etc.

Hello:

I am trying to determine that if a range of cells are marked with an "X", then cells containing "Pass" (A4), Pass with Opportunity for Improvement (A6)or "Fail" (A8) will be marked with an "X". I have 3 columns that are selectable for Pass, Fail, and Non-Applicable. There are a total of thirteen questions that this evaluation form asks, and the evaluator must check one box. In order to be considered a Pass, there must be more 12 or more "X"'s marked in the Pass column. A Pass with Opportunity for Improvement would be equal to 11 marked in the Pass column, and a Failure would be 10 or less showing up in the Fail column. If there is a check in the non-applicable section, this has to be figured into thye pass fail as well. A Pass would be 85% or higher, and failure anything less than this. I will attach the file for review. I would very much appreciate help on this problem first, and then there is one other element to the sheet that plays in at the end. Thank you very much.

I am unsure how to attach the file in the proper format, ie .zip!! It is an Excel 2007 file. HELP!!!

save your sheet in 2003 format and then select the file, right click and > send to compressed folder.

You can then attach it - use the manage attachments button on the reply page.

Ed

Here is the File. Thanks EdMac.

Bemidji

I have made some amendments to the layout - let me know if you can live with them.

I like what you did here (formula & functionality), this is close to the end result I desire. However, this form will be used to do work center evaluations, and then the data will be entered into the computer, and electronic copies distributed.

Can we keep the "X" concept, or at least evaluate it both ways??

Thank you.

Any other Thoughts, comments???

I think EdMac has some great ideas, please look at both attachments and see what you can figure out. Any help would be greatly appreciated!!