D David Biddulph Apr 20, 2009 #3 If criteria in *two* other columns, it sounds like SUMPRODUCT, not SUMIF.