Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Could please someone check my formula of SUMPRODUCT as attached? I don't know what's wrong, ussually it works

    Thanks and regards

    Indra
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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)

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many, many thanks. : )

    best regards

    Indra

  4. #4
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    Attached Files Attached Files
    Regards
    Prasad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •