Jul 26 2018 06:47 AM
I need to multiply the cost per piece & the number of pieces being ordered. I need the formula to continue down the entire column. The formula I'm using for an example is =SUM(J111*H111)
I need that formula repeated in column H continuously with the correct corresponding cell numbers. It was working fine, although I don't recall how I did it. Now the cell numbers are mixed up.
I hope I explained myself correctly. Any help would be appreciated.
Jul 26 2018 07:01 AM
Hi Eileen,
You sum nothing, just multiply the price on number of pieces, thus formula like
=J103*H103
is enough
And your formula for 110 is wrong, it looks like
=SUM(J110,H110)
it shall be * instead of comma. Even better
=J110*H110
Jul 26 2018 07:08 AM
Jul 26 2018 07:43 AM
SolutionEileen,
- enter formula in the first cell of your range, let say =J1*H1 in cell K1;
- select your range in column K, let say cells from K1 to K200;
- press Ctrl+D
It's not necessary to empty your range before
Jul 26 2018 07:51 AM
Thank you very much! Going to try it now.
Have a wonderful day!
Jul 26 2018 07:43 AM
SolutionEileen,
- enter formula in the first cell of your range, let say =J1*H1 in cell K1;
- select your range in column K, let say cells from K1 to K200;
- press Ctrl+D
It's not necessary to empty your range before