Forum Discussion
Excel add same formula easy way
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.
Hi there,
For this purposes, using absolute references will help. All you have to do is to fix a cell (named as absolute reference) by writing its reference as $A$1. In this way, you are fixing both the column and the row of that reference.
Then, use =$A$1*C1 to perform your desired calculation and lastly fill this formulation to the right to fill until Z1. Being the cell A1 fixed, it will not change as you drag the formula. C1 will naturally change as you are dragging to the right, so it will basically change from C1 to D1 to E1...
See attached workbook for illustration.
Martin
- Hi all,
First of all thank you for your response.
Those answers are not good, because you put the solution to C2-Z2.
The solution have to be C1-Z1. Where the numbers are.
The original numbers have to change.
So, when A1 value is 1 it shows which are the basic numbers.
This is why I have to add the formula to the original cells.
You can simplify this by using the SUMPRODUCT function. Instead of writing individual formulas like +A1*C1, you can use:
=SUMPRODUCT(A1, C1:Z1)This will multiply the value in A1 with each cell in the range C1:Z1 and automatically update whenever A1 changes. This way, you don’t need to manually update each formula, and the results will always stay in sync. Similarly, just as DixMax automatically updates and syncs your movie or TV app experience across multiple devices, using SUMPRODUCT streamlines and updates your calculations efficiently without needing constant manual changes. It’s all about simplifying workflows, whether it’s for data or entertainment management!
As variant =C1*$A$1 in C2, select C2:Z2, Ctrl+R
