How can I do one single formula to sum two ranges and display them in their respective column.
Here I’m using SUM formula in each cell but I’m sure there must be a single formula that can accomplish this.
Value 1 and Value 2 are the ranges to add them together in Sum row.
Here is an example picture.
>Solution :
Since arrayformula does not support sum, I suppose you could also do this in C12:
=arrayformula(C10:I10+C11:I11)
