Sumproduct and Sumif in vba in large datasheet

[Jean72]

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

Thanks for any can help

[snb]

I'd use a pivottable