Excel - sum base on row and multiple columns

2
votes

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

Input:

enter image description here

Output: need for all rows

enter image description here

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

1
excel-2010sumifs
I didn't understand, what do you have to do? I don't see any 18 or 5 labels – Jacopo Mosconi
Thanks, edited in my post. 15 and 8 are columns names – Mutum Pamel
You have to sum all the columns 15 and 8? – Jacopo Mosconi
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
I don't know if it youll work for you, but have you tried DSUM ? – AirlineDog

1 Answers

1
votes

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