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.
View best response
You sum nothing, just multiply the price on number of pieces, thus formula like
And your formula for 110 is wrong, it looks like
it shall be * instead of comma. Even better
- 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
Thank you very much! Going to try it now.
Have a wonderful day!
Thanks, you too