Hello,

I have this formula in a cell (K27 but irrelevant)
=($E$70*C4)+($E$71*C5)+($E$72*C6)+($E$73*C7)+($E$74*C8)+($E$75*C9)+($E$76*C10)

E70:E76 is a set of prices that will stay constant.

C4:C10 is a set of quantities.

I want to drag down and autofill from K27. E70:E27 will stay constant because of $ which is good.

Here is the tricky part. in K28 I want the formula to have replaced C4:C10 with E4:E10. so autofill should take from every other column. Is there any way to do this, there has to be a way to do it without doing it manually

Thanks