multiplying all data in column A with all data in column B
Row by row: C1: =A1*B1, C2: =A2*B2, C3: =A3*B3 … or do you want a SUMPRODUCT() (Multiply row by row and sum products) or would you like to create a matrix of products?
multiplying all data in column A with all data in column B
Row by row: C1: =A1*B1, C2: =A2*B2, C3: =A3*B3 … or do you want a SUMPRODUCT() (Multiply row by row and sum products) or would you like to create a matrix of products?