Since the 3rd argument is a logical value, as long as the criteria range is the same for multiple criteria, why not nest the AND function inside the SUMIFS function, where the individual criteria are the arugments for the AND. For older versions without SUMIFS, that should work to permit multiple criteria with the same criteria range in the SUMIF function, right?