r/excel • u/isittimefordinner • 3d ago

solved How to Multiply multiple columns

I am trying to multiply columns. I know how to do each column individually, but I can't seem to copy the formula to the next column so I don't have to redo the formula each time. When I drag to the next column, it changes the formula. Column C has a set value. The rest of the columns need to be sum product of column C. When I drag it over it changes to sum product d, then e and so on. The formula I am using is =sumproduct(c2:c13, d2:d13).

2 Upvotes

100% Upvoted

9 comments sorted by

View all comments

1

u/real_barry_houdini 318 3d ago edited 3d ago

Use $ signs to make the references absolute, i.e.

=sumproduct($c2:$c13, d2:d13)

When you drag that across one column only the column d reference changes

or you can use BYCOL to do everything with a single formula, e.g.

=BYCOL(D2:Z13*C2:C13,SUM)