I have a list of criteria, 1 through, for example, which measures different aspects of a "deal", rates it simply if it is complete or completed accurately or not. The criteria list will be weighted based on importance. Not all the criteria will be applicable. so either 1, 0, or N\A with final score for each based on 100 maximum points. But how do I create a scoring matrix to which will score consistently from one deal to the next. For example if deal #1 only has 8 of 10 criteria applicable versus the next deal #2 has 10 of 10 criteria applicable, how can these two be scored and compared consistently without the lesser used criteria deal score being impacted as a result of using less fields. make sense? Any insight on how to set up appreciated!!