perhaps on your summary sheet, for each type of record, and for each type of appl, use =countif(range,"negative) etc?