Tag Info

Hot answers tagged


Add the following formula in K1: =ARRAYFORMULA(H:H * J:J)) If you have a header in the first row, then do this: =ARRAYFORMULA(H2:H * J2:J)) To avoid the remaining zero's, best is to select a fixed range: =ARRAYFORMULA(H2:H250 * J2:J250)) Reference Google Drive Help: ARRAYFORMULA

Only top voted, non community-wiki answers of a minimum length are eligible