I need to do a number of SUMIF functions, however in reverse. So instead of a specific value as the criteria, I want the criteria to be everything BUT that specific value. In otherwords, I am trying to exclude that value from the sum. Any ideas?