Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Problem | Excel Discussion (Misc queries) | |||
Problem using SUMPRODUCT | New Users to Excel | |||
SUMPRODUCT problem | Excel Worksheet Functions | |||
SUMPRODUCT problem | Excel Discussion (Misc queries) | |||
SUMPRODUCT Problem | New Users to Excel |