Results 1 to 4 of 4

sumproduct error

Threaded View

  1. #1
    Registered User
    Join Date
    02-20-2012
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2010
    Posts
    74

    sumproduct error

    Hi, I really hope someone can help me solve this problem because it is driving me mad. I got it to work in a different workbook but now its not summing properly.

    My formula is as follows: =IFERROR(VLOOKUP($B20,$J$11:$O$45,HLOOKUP(CONCATENATE($K$6,$D$10),$L$1:$O$2,2,FALSE),FALSE),SUMPRODUCT(($B$11:$B$36="Other")*($L$11:$L$36))+SUMPRODUCT(($B$11:$B$36="")*($L$11:$L$36)))

    it is giving me a result of $39,680 but it should be giving me $40,073. I am attaching an example.

    Thanks in advance for your help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1