Sum by Row Criteria and Column Header

Hello,

I am looking for VBA Array or Scripting Dictionary Method to solve the problem, currently i am using the "SUMPRODUCT" formula to get the sum values based on row and column criteria.

Data is the main sheet , using Sum product i am getting the values to output, this sample file only in original file having more rows and columns.

Need code to get until last row and last column

Any help appreciated.

there is simple and power way

Formula:

Please Login or Register  to view this content.

in the case of date is arranged then

Formula:

Please Login or Register  to view this content.

Hello Bo_Ry,

I tested the code, its just consolidating from Sheet "DATA" to "OUTPUT" sheet, sometimes the data in sheet "DATA" will be different,

to "OUTPUT" sheet.

Example - In "DATA" sheet there is no Jun-20 month then the "Jun-20" in "OUPUT" sheet should be blank.

I need only the number values in month column based on the highlighted criteria and no other details should be changed.

Hello Bo_Ry

The column range should be dynamic, currently its fixed to BB1

Thanks Bo_Ry, it worked