Sumproduct and Sumif in vba in large datasheet

Hi
I am a newbie in vba, just start learning.

Annexed file, how to a write vba code to automate processing for sumproduct and sumifs up to columns end of if possible.

Amount sumproduct and Amount_1 sumifs :confused:

Thanks for any can help

I'd use a pivottable