=SUMPRODUCT((I6:K6="Yes")*OFFSET(Table7[[#Headers],[Windows- Size in Square Footing]],MATCH(C6,Table7[Windows- Size in Square Footing],TRUE),4,1,3))+SUMPRODUCT((F6:H6="Yes")*OFFSET(Table7[[#Headers],[Windows- Size in Square Footing]],MATCH(C6,Table7[Windows- Size in Square Footing],TRUE),1,1,3)*IF(F6="Yes",IF(E6="Capping",1,0.85),1))*D6
This is my formula in my attached spreadsheet for the Cost column.
For some reason columns I,J,K are not multiplying by the quanity ?
Any help would be appreciated!!
Thanks in advance!:)forum.ozgrid.com/index.php?attachment/60649/