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 ...
Write this formula in cell C1 and fill down:
=IF(SUM(A1+B1)=0, "", SUM(A1+B1))
- You may adjust cell references in the formula as needed.