Excel - sum base on row and multiple columns

Question

How to get sum of column labels 15 and 8 of a particular date

Input:

Output: need for all rows

One way is do sum along horizontal yet not sure to match the dates... I have >50K columns in real dataset. sumif along rows link https://exceljet.net/formula/sumifs-with-horizontal-range

I didn't understand, what do you have to do? I don't see any 18 or 5 labels — Jacopo Mosconi, Dec 19 '20 at 13:38
for full expression, I have added full expected output. eg. the entry 351.41 for 1/1/2014 corresponds to sum of all values (58.92,40.58,61.94,34.43,8.27,230.55) in Input table with column name '15' — Mutum Pamel, Dec 19 '20 at 14:03
I don't know if it youll work for you, but have you tried DSUM ? — AirlineDog, Dec 19 '20 at 14:22

score 1 · Answer 1 · answered Dec 19 '20 at 13:57

1

you can write this in the cell where you want the result of first row:

=FIRSTCELL + SECONDCELL + THIRDCELL ecc...

where firstcell is like "A3"..

after simply select the cell where you got the result, a dot appears in the lower right of the cell, drag it down, and in the cells below you will get the result of the other rows

answered Dec 19 '20 at 13:57

Jacopo Mosconi

972
8
22

Not sure I can do that, I have more than 5K columns in my real dataset – Mutum Pamel Dec 19 '20 at 14:04
One thing I can use sumifs along rows , yet not sure to match the dates https://exceljet.net/formula/sumifs-with-horizontal-range – Mutum Pamel Dec 19 '20 at 14:06
Maybe use that formula and set your range by using the OFFSET function (use MATCH for column) – P.b Dec 20 '20 at 13:13

Excel - sum base on row and multiple columns

1 Answers1