Discussion Re: SUM formula help needed with multiple criteria in Excel
https://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219239#M14883
<P>Thanks, you too</P>Thu, 26 Jul 2018 15:22:15 GMTSergei Baklan2018-07-26T15:22:15ZSUM formula help needed with multiple criteria
https://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219211#M14876
<P>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)</P><P>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. </P><P>I hope I explained myself correctly. Any help would be appreciated. </P>Thu, 26 Jul 2018 13:47:24 GMThttps://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219211#M14876Eileen Skidgel2018-07-26T13:47:24ZRe: SUM formula help needed with multiple criteria
https://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219214#M14877
<P>Hi Eileen,</P>
<P> </P>
<P>You sum nothing, just multiply the price on number of pieces, thus formula like</P>
<PRE>=J103*H103</PRE>
<P>is enough</P>
<P>And your formula for 110 is wrong, it looks like</P>
<PRE>=SUM(J110,H110)</PRE>
<P>it shall be * instead of comma. Even better</P>
<PRE>=J110*H110</PRE>
<P> </P>Thu, 26 Jul 2018 14:01:08 GMThttps://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219214#M14877Sergei Baklan2018-07-26T14:01:08ZRe: SUM formula help needed with multiple criteria
https://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219217#M14878
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?Thu, 26 Jul 2018 14:08:53 GMThttps://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219217#M14878Eileen Skidgel2018-07-26T14:08:53ZRe: SUM formula help needed with multiple criteria
https://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219224#M14879
<P>Eileen,</P>
<P>- enter formula in the first cell of your range, let say =J1*H1 in cell K1;</P>
<P>- select your range in column K, let say cells from K1 to K200;</P>
<P>- press Ctrl+D</P>
<P> </P>
<P>It's not necessary to empty your range before</P>Thu, 26 Jul 2018 14:43:33 GMThttps://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219224#M14879Sergei Baklan2018-07-26T14:43:33ZRe: SUM formula help needed with multiple criteria
https://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219227#M14881
<P>Thank you very much! Going to try it now.</P><P> </P><P>Have a wonderful day!</P>Thu, 26 Jul 2018 14:51:17 GMThttps://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219227#M14881Eileen Skidgel2018-07-26T14:51:17ZRe: SUM formula help needed with multiple criteria
https://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219239#M14883
<P>Thanks, you too</P>Thu, 26 Jul 2018 15:22:15 GMThttps://techcommunity.microsoft.com/t5/excel/sum-formula-help-needed-with-multiple-criteria/m-p/219239#M14883Sergei Baklan2018-07-26T15:22:15Z