Forum Discussion
Function for summing corresponding rows
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 ...
Ensure your fill handle option is enabled (File/Options/Advanced/Enable fill handle and cell drag and drop).
Enter =A1+B1 in cell C1.
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.
Enter =A1+B1 in cell C1.
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.