Forum Discussion
HLennen
Mar 31, 2022Copper Contributor
Column Multiplication formula
Hello everyone, Very new to Excel here and I was wondering if there was a formula that would give me the sum of two columns without having to manually input the individual cell every time. For examp...
SergeiBaklan
Mar 31, 2022Diamond Contributor
In C1 enter =A1*B1, select entire range (e.g. C1:C1000) and Ctrl+D
Or double click on the dot in right bottom when you stay on C1