Create Summary

[Foncesa]

Hi,

I want to create summary from this data, I am confused how to generate this summary. Please some one help me.
I have have attached the sample work book.

30078


Thanks.

[p45cal]

After changing the data in the 2 blue tables on the left, right-click somewhere in the table at cell J2 and choose Refresh to update the results.
(It's a Power Query solution)

[arnelgp]

here is a VBA.

[snb]

This is more a question how to structure the data, than how to calculate.