Hello,

I have numbers in C1 till Z1 cells.

I would like to multiply these cells value with A1 value.

Example: +A1*C1, +A1*B1……+A1*Z1

I know I could write one by one. 

But is there a simple way to add all cells to this formula?

So if I change A1 cell value all the values have to change. C1-Z1 is not fixed. It have to change when A1 changing.

​Hello,I have numbers in C1 till Z1 cells.I would like to multiply these cells value with A1 value.Example: +A1*C1, +A1*B1……+A1*Z1I know I could write one by one. But is there a simple way to add all cells to this formula?So if I change A1 cell value all the values have to change. C1-Z1 is not fixed. It have to change when A1 changing.  Read More

​