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
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