Oct 02 2020 02:12 PM - edited Oct 02 2020 02:13 PM
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.
Included a picture of an example excel sheet to help visualize.
Oct 02 2020 11:07 PM
Write this formula in cell C1 and fill down:
=IF(SUM(A1+B1)=0, "", SUM(A1+B1))
Oct 02 2020 11:08 PM
Oct 03 2020 12:41 PM
In you case what @JMB17 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).
If to fill horizontally, i.e. the row, same or similar but with Ctrl+R
Oct 03 2020 04:42 PM