Sum two ranges separately in one formula

user_8157523 0
Viewed 91

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. enter image description here

google-sheets
2 Answers

Since arrayformula does not support sum, I suppose you could also do this in C12:

=arrayformula(C10:I10+C11:I11)

output

user_161186860

Clear the formula you have in row 12 and then enter in C12

=index(mmult({1,1}, --C10:I11))

Change range to suit and see if that helps?

user_38894230
Related