yes, no drop downs; multiplying by QTY column?

  • =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/

  • Re: yes, no drop downs; multiplying by QTY column?


    Can you explain further what you mean by "For some reason columns I,J,K are not multiplying by the quanity ? " ?


    Can you give expected results and how they are gotten?

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!