Forum Discussion
I need help creating a formula!
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 th...
For qty ordered
=SUMPRODUCT(L4:ZZ4*(MOD(COLUMN(L4:ZZ4),4)=0))
etc
Thank you for your help, but it didn't work. i found a round about way.