Aggregate multiple (many!) pair of columns (Exce)

I have table; The table consists of pairs of date and value columns

 Pair               Pair              Pair            Pair           .... ..... ......

enter image description here

What I need is the sum of all values for the same date.
The total table has 3146 columns (so 1573 pairs of value and date)!! with up to 186 entries on row level.

Thankfully, the first column contains all possible date values.

Considering the 3146 columns I am not sure how to do that without doing massivle amount of small steps 🙁

Leave a Reply

Your email address will not be published. Required fields are marked *