Sumprpoduct Help

[Merlin54k]

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,FALSE)),0,VLOOKUP($M85,REMS2007!$M$4:$P$1786,4,FALSE))

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.

[Magnivy]

Is the format in cell P93 set to percentage?

"Merlin54k" wrote:

>
> 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,FALSE)),0,VLOOKUP($M85,REMS2007!$M$4:$P$1786,4,FALSE))
>
> 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.
>
>
> --
> Merlin54k
> ------------------------------------------------------------------------
> Merlin54k's Profile: http://www.excelforum.com/member.php...o&userid=35199
> View this thread: http://www.excelforum.com/showthread...hreadid=549652
>
>

[Marcelo]

try to see

http://www.bettersolutions.com/excel...U014532021.htm

regards from Brazil
Marcelo

"Merlin54k" escreveu:

>
> 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,FALSE)),0,VLOOKUP($M85,REMS2007!$M$4:$P$1786,4,FALSE))
>
> 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.
>
>
> --
> Merlin54k
> ------------------------------------------------------------------------
> Merlin54k's Profile: http://www.excelforum.com/member.php...o&userid=35199
> View this thread: http://www.excelforum.com/showthread...hreadid=549652
>
>

[Merlin54k]

Yes, P83 is a percentage, formatted to percentage.

[Merlin54k]

Yes, P83 is a percentage, formatted to percentage.

[Merlin54k]

Yes, P83 is a percentage, formatted to percentage.