Google sheets – multiply two columns, copy third column


probably very simple question but yeah, dont know how of course.

I have 3 columns:

A  B  C
5  1  A
5  2  B
5  3  C

and want to multiply column A and B, and just copy C column. All with one expresion.
So Result of multiplication A and B should be in D and result of copying should be in F:

Final result should be:

5 A
10 B
15 C

Is there any simple method to do something like this?


this should do:

=INDEX({A1:A3*B1:B3, C1:C3})

or if you are on non-english sheet:

=INDEX({A1:A3*B1:B3\ C1:C3})

Answered By – player0

Answer Checked By – Gilberto Lyons (AngularFixing Admin)

Leave a Reply

Your email address will not be published.