• Please check my Sumproduct

    Author
    Topic
    #465020

    Could please someone check my formula of SUMPRODUCT as attached? I don’t know what’s wrong, ussually it works

    Thanks and regards

    Indra

    Viewing 2 reply threads
    Author
    Replies
    • #1192962

      The values in your Code column are not whole numbers so they do not match the values in the B column next to the SUMPRODUCT table

      You can round the values in the Code column by using:

      Code:
      =SUMPRODUCT((ROUND($C$11:$C$25,0)=$B2)*($B$11:$B$25=C$1),$D$11:$D$25)
    • #1192963

      Many, many thanks. : )

      best regards

      Indra

    • #1192965

      Further to reply of mdbct, you need to expand the criteria code in Col. B. In col. C, there are 5 code starting with 24 and none is identical to other. Better to use a drop down list.

    Viewing 2 reply threads
    Reply To: Please check my Sumproduct

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: