Hi, I do a bunch of auditing in my position, and am wondering how to develop a certain kind of audit, and I assume it can be done in excel. I want to have a spreadsheet with audit questions, and in a seperate column with the ability to put met/unmets. What I am looking for is a way to have the mets/unmets tabulated and if they reach a certain level for unmets (say 4/15) then an unmet would be the result, which i would need to display either in a word, or chart of some sort. I have no problem doing the leg work for this, I just need an idea of which is the best way to proceed, as I am somewhat familiar with formulas, but the "if" formula isnt one of my strongest.