How to multiply columns in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2221039%22%20slang%3D%22en-US%22%3EHow%20to%20multiply%20columns%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2221039%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20to%20get%20totals%20in%20my%20report%20by%20multiplying%20columns%20in%20excel.%26nbsp%3B%20But%20NOT%20with%20a%20constant%20number.%26nbsp%3B%20The%20value%20of%20the%20numbers%20is%20different%20for%20each%20line.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2221039%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm looking to get totals in my report by multiplying columns in excel.  But NOT with a constant number.  The value of the numbers is different for each line.

1 Reply

@OliviaOrtiz98 

 

Your request is more than a little confusing, I'm afraid.

Totals are the result of adding, yet you are talking of multiplying (which yields "products").

 

And multiplying is actually fairly easy (=A1*B1, for example), and a formula like that could be copied down row after row, using different variables in each case (whatever is in A2 by whatever is in B2).

 

So could I suggest you post a copy of the workbook you're using, with a bit more of an explanation of the desired result.