I need help creating a formula!

Question

I need&nbsp;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.&nbsp;&nbsp;I appreciate any help!

sergeibaklan · Answer

For qty ordered
=SUMPRODUCT(L4:ZZ4*(MOD(COLUMN(L4:ZZ4),4)=0))
etc
&nbsp;

mariloy · Answer

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

Forum Discussion

I need help creating a formula!

Share

Resources