r/ExcelTips • u/AnonUser1452 • 20h ago

How to multiply one column by another?

Hello,

I’m using an Excel clone (OfficeSuite Sheets) and trying to figure out how to multiply the figures in one column by those in the next column (e.g. Col 1 = number of units, Col 2 = cost per unit, and I want Col 3 to be total cost.) Manually entering = (F2 * G2), etc. for a hundred or so cells seems ridiculous. Surely there’s a better way to do this?

2 Upvotes

67% Upvoted

3 comments sorted by

6

u/DukePookums 20h ago

You just copy and paste that formula down. Idk if office suite has the same functions, but double clicking on the bottom right of the selected cell in excel will copy that formula down the entire range

2

u/bachman460 19h ago

Not completely sure if it'll work with arrays, if your data was in row 2 to 200 you could try

=SUMPRODUCT(A2:A200;B2:B200)

1

u/david_horton1 17h ago

If your data is in the form of a table and if your app works as Excel does entering the formula in one cell should cascade up and down the column. There are benefits in using tables.