To take one action when a cell is equal to a certain value, and another when not equal, you can use the IF function In the example shown, the formula in cell D6 is = IF(B6 = "red","x","") · Not necessarily, you need to use the same number for cells eg B2 in order to SUMPRODUCT function work This formula will also work =SUMPRODUCT(,B2B5) As such, the dimensions are the same In this case, this is how SUMPRODUCT will multiply and sum * B2 A5* A6 * B4 * B5 Sum Getting the SUM of only specific product exampleIn Excel, most of us may suffer to multiply two columns and then add them up, of course, we can multiply each items and then sum them, but this will be troublesome if there are hundreds or thousands rows need to calculate In Excel, there is a powerful function – SUMPRODUCT, with it, we can quickly multiply two columns and then sum them
Basic Excel Formula Multiply Divide Add Subtract In Excel Youtube
Excel formula multiply cell by number