I need help creating a formula!

[mariloy]

I need to create a formula, in order to calculate the total sum for each product, for each column separately(products ordered, products, received, etc) (please see attached file). Please note that they are not only the 5 weeks that are written, this file will be used for the full year worth of products. 

I appreciate any help!

[#2]

For qty ordered

=SUMPRODUCT(L4:ZZ4*(MOD(COLUMN(L4:ZZ4),4)=0))

etc

[#3]

Thank you for your help, but it didn't work. i found a round about way.