Forgive me if this is simple, but I have not been able to find an answer yet.
I am interested in multiplying two values, and dragging the formula vertically along side the data that is in a column. The values I want to multiply it by is arranged in a row, and needs to stay in a row. I am wondering how I can drag the formula vertically while having the variable in the row follow.
Ex. I have data in M2-M10 and want to create a formula that I can drag from N2-N10 that multiplies the M column data by values in A1-I1.
Bookmarks