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.
Bookmarks