Discussion Re: Function for summing corresponding rows in Excel
https://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1742731#M76873
Just to throw out one other option for the op in that scenario, I normally select a cell in the column containing the existing data (say column B). Then, hit Ctrl+Down Arrow to get to the bottom row of the range. Then go over to the column I want to fill and input something (anything) in the cell in the column I want to fill. Then ctrl+up arrow, input the formula, copy, ctrl+shift+down arrow, and enter (paste).Sat, 03 Oct 2020 23:42:54 GMTJMB172020-10-03T23:42:54ZFunction for summing corresponding rows
https://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1740833#M76799
<P>Hello, I'm trying to find a function that can sum up two numbers if their row number matches. For example, if Column A and Column B are my data sets, then I want a general function f(A_n, B_n) = A_n + B_n whose results will pop up in Column C. I'm aware that you can do a sum and then drag the AutoFill function over the sets I have. But, my Columns A and B are extremely long so dragging AutoFill presents a nuisance. Hoping someone can help me define a function with Excel's Formula feature or maybe using tables. Any assistance appreciated. </P><P> </P><P>Included a picture of an example excel sheet to help visualize. </P>Fri, 02 Oct 2020 21:13:06 GMThttps://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1740833#M76799robbox2020-10-02T21:13:06ZRe: Function for summing corresponding rows
https://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1741489#M76820
<P><EM>Write this formula in cell C1 and fill down:</EM></P><P> </P><P> </P><LI-CODE lang="applescript">=IF(SUM(A1+B1)=0, "", SUM(A1+B1))</LI-CODE><P> </P><UL><LI>You may adjust cell references in the formula as needed.</LI></UL>Sat, 03 Oct 2020 06:07:54 GMThttps://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1741489#M76820Rajesh-S2020-10-03T06:07:54ZRe: Function for summing corresponding rows
https://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1741490#M76821
Ensure your fill handle option is enabled (File/Options/Advanced/Enable fill handle and cell drag and drop).<BR /><BR />Enter =A1+B1 in cell C1.<BR /><BR />Then, hover the cursor over the bottom right of cell C1 (over the little black square). When the cursor turns to a black cross, double click.<BR /><BR />Sat, 03 Oct 2020 06:08:45 GMThttps://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1741490#M76821JMB172020-10-03T06:08:45ZRe: Function for summing corresponding rows
https://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1742515#M76863
<P><LI-USER uid="818262"></LI-USER> </P>
<P>In you case what <LI-USER uid="675152"></LI-USER> suggested is most effective. Just in case, if formula is not in adjacent column, e.g. in column F, enter formula in F1, in Name Box (under top left of the sheet grid) type the reference on the range to be filled (e.g. F1:F999999), Enter (range will be selected), Ctrl+D (formula will be filled into the range).</P>
<P>If to fill horizontally, i.e. the row, same or similar but with Ctrl+R</P>Sat, 03 Oct 2020 19:41:04 GMThttps://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1742515#M76863Sergei Baklan2020-10-03T19:41:04ZRe: Function for summing corresponding rows
https://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1742731#M76873
Just to throw out one other option for the op in that scenario, I normally select a cell in the column containing the existing data (say column B). Then, hit Ctrl+Down Arrow to get to the bottom row of the range. Then go over to the column I want to fill and input something (anything) in the cell in the column I want to fill. Then ctrl+up arrow, input the formula, copy, ctrl+shift+down arrow, and enter (paste).Sat, 03 Oct 2020 23:42:54 GMThttps://techcommunity.microsoft.com/t5/excel/function-for-summing-corresponding-rows/m-p/1742731#M76873JMB172020-10-03T23:42:54Z