|
Sumprpoduct Help
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. :confused: -- Merlin54k ------------------------------------------------------------------------ Merlin54k's Profile: http://www.excelforum.com/member.php...o&userid=35199 View this thread: http://www.excelforum.com/showthread...hreadid=549652 |
Sumprpoduct Help
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,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. :confused: -- Merlin54k ------------------------------------------------------------------------ Merlin54k's Profile: http://www.excelforum.com/member.php...o&userid=35199 View this thread: http://www.excelforum.com/showthread...hreadid=549652 |
Sumprpoduct Help
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,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. :confused: -- Merlin54k ------------------------------------------------------------------------ Merlin54k's Profile: http://www.excelforum.com/member.php...o&userid=35199 View this thread: http://www.excelforum.com/showthread...hreadid=549652 |
Sumprpoduct Help
Yes, P83 is a percentage, formatted to percentage. :confused: -- Merlin54k ------------------------------------------------------------------------ Merlin54k's Profile: http://www.excelforum.com/member.php...o&userid=35199 View this thread: http://www.excelforum.com/showthread...hreadid=549652 |
Sumprpoduct Help
Yes, P83 is a percentage, formatted to percentage. :confused: -- Merlin54k ------------------------------------------------------------------------ Merlin54k's Profile: http://www.excelforum.com/member.php...o&userid=35199 View this thread: http://www.excelforum.com/showthread...hreadid=549652 |
Sumprpoduct Help
Yes, P83 is a percentage, formatted to percentage. :confused: -- Merlin54k ------------------------------------------------------------------------ Merlin54k's Profile: http://www.excelforum.com/member.php...o&userid=35199 View this thread: http://www.excelforum.com/showthread...hreadid=549652 |
| All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com