Multiple columns & rows

Hi all,

it may be a very easy one, but I couldn't solve it on my own.
here is how it looks:

Untitled.png


I have a column with dates, where I need to multiply 0.3 with each total from columns independently, ex:
1x0.3
3x0.3
6x0.3
10x0.3
15x0.3
21x0.3
28x0.3

I can do it manually, but I was wondering if there is a formula for this, its basically multiplying rows with columns.
my problem is that I can't drag the formula down because the source is in columns - horizontal

thank you in advance

thank you for the reply, here is the attachment

also, while we are on it, would be very happy if you please check my formulas for DAU columns from 1 to 30, what do you think of the formulas? is there a more elegant way to copy paste the same numbers? e.g. 100.000 for each DAU day?
thank you in advance

Hi Glenn,
thanks a lot for the reply & formula, very elegant

as per the original question, I am trying to multiply the ARPDAU rows with DAU columns and paste the result to Revenue (highlighted in blue),
e.g.
F5*I37 = 30.000, D0 revenue = 30.000$
F6*J37 = 42.000, D1 revenue = 42.000$ and so on.
I am trying to figure out how to "drag" the formula, where columns are changed automatically, like I37 to J37

hope this makes sense

thank you very much Glenn, I see that OFFSET is the key here will def learn more about it..

thank you, have a great day!