SOLVED
Home

SUM formula help needed with multiple criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-219211%22%20slang%3D%22en-US%22%3ESUM%20formula%20help%20needed%20with%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219211%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20multiply%20the%20cost%20per%20piece%20%26amp%3B%20the%20number%20of%20pieces%20being%20ordered.%20I%20need%20the%20formula%20to%20continue%20down%20the%20entire%20column.%20The%20formula%20I'm%20using%20for%20an%20example%20is%26nbsp%3B%20%3DSUM(J111*H111)%3C%2FP%3E%3CP%3EI%20need%20that%20formula%20repeated%20in%20column%26nbsp%3BH%20continuously%26nbsp%3Bwith%20the%20correct%20corresponding%26nbsp%3Bcell%20numbers.%20It%20was%20working%20fine%2C%20although%20I%20don't%20recall%20how%20I%20did%20it.%20Now%20the%20cell%20numbers%20are%20mixed%20up.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20explained%20myself%20correctly.%20Any%20help%20would%20be%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-219211%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219239%22%20slang%3D%22en-US%22%3ERe%3A%20SUM%20formula%20help%20needed%20with%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219239%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20you%20too%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219227%22%20slang%3D%22en-US%22%3ERe%3A%20SUM%20formula%20help%20needed%20with%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219227%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much!%20Going%20to%20try%20it%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20wonderful%20day!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219224%22%20slang%3D%22en-US%22%3ERe%3A%20SUM%20formula%20help%20needed%20with%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219224%22%20slang%3D%22en-US%22%3E%3CP%3EEileen%2C%3C%2FP%3E%0A%3CP%3E-%20enter%20formula%20in%20the%20first%26nbsp%3Bcell%20of%20your%20range%2C%20let%20say%20%3DJ1*H1%20in%20cell%20K1%3B%3C%2FP%3E%0A%3CP%3E-%20select%20your%20range%20in%20column%20K%2C%20let%20say%20cells%20from%20K1%20to%20K200%3B%3C%2FP%3E%0A%3CP%3E-%20press%20Ctrl%2BD%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20not%20necessary%20to%20empty%20your%20range%20before%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219217%22%20slang%3D%22en-US%22%3ERe%3A%20SUM%20formula%20help%20needed%20with%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219217%22%20slang%3D%22en-US%22%3EThank%20you!%20I%20appreciate%20your%20help.%20It's%20much%20simpler%20than%20I%20thought.%20Now%20the%20most%20important%20question...%20Is%20there%20a%20way%20to%20have%20that%20formula%20repeat%20in%20column%20K%20continuously%3F%20Without%20having%20to%20type%20in%20the%20formula%20in%20each%20cell%20in%20the%20column%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219214%22%20slang%3D%22en-US%22%3ERe%3A%20SUM%20formula%20help%20needed%20with%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219214%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Eileen%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20sum%20nothing%2C%20just%20multiply%20the%20price%20on%20number%20of%20pieces%2C%20thus%20formula%20like%3C%2FP%3E%0A%3CPRE%3E%3DJ103*H103%3C%2FPRE%3E%0A%3CP%3Eis%20enough%3C%2FP%3E%0A%3CP%3EAnd%20your%20formula%20for%20110%20is%20wrong%2C%20it%20looks%20like%3C%2FP%3E%0A%3CPRE%3E%3DSUM(J110%2CH110)%3C%2FPRE%3E%0A%3CP%3Eit%20shall%20be%20*%20instead%20of%20comma.%20Even%20better%3C%2FP%3E%0A%3CPRE%3E%3DJ110*H110%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Eileen Skidgel
New Contributor

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. 

5 Replies
Highlighted

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

 

Highlighted
Thank you! I appreciate your help. It's much simpler than I thought. Now the most important question... Is there a way to have that formula repeat in column K continuously? Without having to type in the formula in each cell in the column?
Highlighted
Solution

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

Highlighted

Thank you very much! Going to try it now.

 

Have a wonderful day!

Highlighted

Thanks, you too