But if you want to use more than one criteria what can you do. Release the Ctrl and Shift keys. The formula below multiplies numbers in a cell.
Create the Formula Select cell C1 to make it the active cell.
Multiple Functions in One Cell A cell introduces functions using an equals sign. Value_if_true argument type Underweight. This process activates all the functions or formulas of excel. You need to use SUMIFS function that is by default designed to sum numbers with multiple criteria based on AND logic.