SUMIF vs SUMIFS vs COUNTIFS: which Excel function to use when

Excel has a whole family of "add this up, but only for some rows" functions, and their names look...