Sumproduct problem
Hello,
I have the following formula: =SUMPRODUCT('Open Reqs by Org'!B1:B1000)*('Open Reqs by Org'! M1:M1000="RC") I am trying to sum column B where the corresponding column in the same row matches the text "RC" This should be fairly simple but I keep getting the value of 0 where it should be around 20. Any suggestions? Thanks, Chris |
Sumproduct problem
Try
=SUMPRODUCT((B1:B1000)*(M1:M1000="RC")) or =SUMPRODUCT(--(M1:M1000="RC"),B1:B1000) add your page names to the formulas -- Regards, Peo Sjoblom "Chris" wrote in message ... Hello, I have the following formula: =SUMPRODUCT('Open Reqs by Org'!B1:B1000)*('Open Reqs by Org'! M1:M1000="RC") I am trying to sum column B where the corresponding column in the same row matches the text "RC" This should be fairly simple but I keep getting the value of 0 where it should be around 20. Any suggestions? Thanks, Chris |
Sumproduct problem
On Oct 26, 4:15*pm, "Peo Sjoblom" wrote:
Try =SUMPRODUCT((B1:B1000)*(M1:M1000="RC")) or =SUMPRODUCT(--(M1:M1000="RC"),B1:B1000) add your page names to the formulas -- Regards, Peo Sjoblom "Chris" wrote in message ... Hello, I have the following formula: =SUMPRODUCT('Open Reqs by Org'!B1:B1000)*('Open Reqs by Org'! M1:M1000="RC") I am trying to sum column B where the corresponding column in the same row matches the text "RC" This should be fairly simple but I keep getting the value of 0 where it should be around 20. Any suggestions? Thanks, Chris- Hide quoted text - - Show quoted text - Thanks the second one worked! |
All times are GMT +1. The time now is 04:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com