Excel's SUMIF and SUMIFS functions both let you add up values that match criteria you specify. The problem is that many people treat them as separate tools: SUMIF for one condition, SUMIFS for ...