When are they used: SUM :- allows for the summation of a specific number of cells, both adjacent and non-adjacent. SUMIF :- allows for the summation of a range of cells that meet a specific criterion. SUMIFS :- allows for the summation of a range of cells that meet a number of different criteria.