Sumproduct or IndexMatch Function

[kylenusser]

Attached is an example file. I have about 100 tables of data I need to sumproduct. All are formatted the same but in the same vertical formation as shown in the sheet. I have been cutting and pasting, making them horizontal, but it is tedious to do for each month. Does anyone know of a way to Sumproduct for the two criteria in Column I and J?? Please and thank you

https://docs.google.com/spreadsheets/d/1fiXqFzwRZiJwirDJpVRAarErsB1F0CuhkuKx2NWV2BY/edit?usp=sharing

 

[Chrisdontm]

It is not necessary to be copying and pasting so much.
If you are copying the whole range and transposing it, then you can copy and paste special "Transpose"...(Well, at least in Excel you can)


I don't know if I follow you all of the way, but perhaps this is what you are wanting;


In cell: I6 put this formula and copy it down:

=SUMIF($A:$A,K6,$C:$C)

Then in cell: J6 put this formula and copy it down:

=SUMIF($A:$A,K6,$D:$D)