+ Reply to Thread
Results 1 to 3 of 3

Sumproduct Help-multiply the results

  1. #1
    Forum Contributor
    Join Date
    06-07-2006
    Posts
    121

    Sumproduct Help-multiply the results

    I am having a problem using Sumproduct. The sumproduct formula is gathering the necessary information using:

    =SUMPRODUCT((($M93='2007 Rems Slide Obl'!$C$4:$C$1918)*('Branches 2007 Budget'!$J93='2007 Rems Slide Obl'!$U$4:$U$1918)*('2007 Rems Slide Obl'!W$4:W$1918)))

    But I am trying to multiply the results from above by the information information in the adjacent cell P93 which is a percentage.

    I was hoping that by doing:
    =SUMPRODUCT((($M93='2007 Rems Slide Obl'!$C$4:$C$1918)*('Branches 2007 Budget'!$J93='2007 Rems Slide Obl'!$U$4:$U$1918)*('2007 Rems Slide Obl'!W$4:W$1918)))*P93
    would give me the results but I receive #Value!

    The information in P93 is a percentage gathered from another tab using:
    =IF(ISERROR(VLOOKUP($M85,REMS2007!$M$4:$P$1786,4,F ALSE)),0,VLOOKUP($M85,REMS2007!$M$4:$P$1786,4,FALS E))

    Is there a way that I can multiply the result in Q83 by P83 to get the percentage. I know that it works by doing copy, paste, special and listing the end results of the percentage.

  2. #2
    excelent
    Guest

    re: Sumproduct Help-multiply the results

    seems to me u got a text value somwhere in ur referenses

    if this 1 is ok

    =SUMPRODUCT((($M93='2007 Rems Slide Obl'!$C$4:$C$1918)*('Branches 2007
    Budget'!$J93='2007 Rems Slide Obl'!$U$4:$U$1918)*('2007 Rems Slide
    Obl'!W$4:W$1918)))


    then check if

    =IF(ISERROR(VLOOKUP($M85,REMS2007!$M$4:$P$1786,4,F
    ALSE)),0,VLOOKUP($M85,REMS2007!$M$4:$P$1786,4,FALS E))

    returns a numeric value



  3. #3
    Forum Contributor
    Join Date
    06-07-2006
    Posts
    121
    The Sumproduct gathers the intended information using but the problem is when I add *P83 to the end of it in an effort to mulitply it to the adjacent cell.

    P83 the adjacent cell produces a number from VLook Up.

    CELL Q85 Has:
    =SUMPRODUCT((($M85='2007 Rems Slide Obl'!$C$4:$C$1918)*('Branches 2007 Budget'!$J85='2007 Rems Slide Obl'!$U$4:$U$1918)*('2007 Rems Slide Obl'!W$4:W$1918)))

    CELL P85 Has (proucing a percentage result):
    =IF(ISERROR(VLOOKUP($M85,REMS2007!$M$4:$P$1786,4,FALSE)),0,VLOOKUP($M85,REMS2007!$M$4:$P$1786,4,FALSE))

    I was hoping that by doing:
    =SUMPRODUCT((($M85='2007 Rems Slide Obl'!$C$4:$C$1918)*('Branches 2007 Budget'!$J85='2007 Rems Slide Obl'!$U$4:$U$1918)*('2007 Rems Slide Obl'!W$4:W$1918)))*P85

    I would get the result in Q85 pro-rates based on the percentage in P85.
    Last edited by Merlin54k; 06-07-2006 at 04:44 PM.

+ Reply to Thread

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