Be sure not to confuse SUMIFS with SUMIF, as they have different argument orders. Basic syntax: First added to Excel in ... long and complex functions that reference a value multiple times.