That went right over my head. Could you try rewording it? Do you mean you could put a classification column, with group 1, group 2, etc? This might help make the sumif/ifs easier to deal with, but it still doesn't help if all of the rows change (I don't think) Also, I didn't understand the use of AND/OR in your example. Sorry