Filter then calculate and add value

I do this manually and want to make this by automatic. My knowledge is only to record macro and this one gets a bit to advanced for me to fix. I try to explain how it should work.. Thanks

Please Login or Register  to view this content.

Some correction added, The first row has headers, should not be included in the process

Please Login or Register  to view this content.

[/QUOTE]