Forum Discussion
Solved
SUM formula help needed with multiple criteria
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 tha...
Eileen,
- 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
Eileen,
- 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!