Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif SumProduct Several Criteria
I need to sum column AL IF column BR = "Y" AND column BJ = "S1". Is this
possible? I've tried: RiskShareCount = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:A L999) but I get Syntax Error. I'm also going to have to count the same records. Is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif SumProduct Several Criteria
There is a bracket misisng at the end
= SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:A L999)) or even = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");AL1:AL 999) should work, assuming that you have a Continental version of Excel that uses ; \(semi-coln) as a separator, not , (comma) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "StephanieH" wrote in message ... I need to sum column AL IF column BR = "Y" AND column BJ = "S1". Is this possible? I've tried: RiskShareCount = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:A L999) but I get Syntax Error. I'm also going to have to count the same records. Is this possible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif SumProduct Several Criteria
No, it's not a Continental version. I'd picked that up from another posting
(doing my homework before I ask ; - ) I just tried: MyTotal = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:A L999)) and got a Syntax error. So I tried: MyTotal = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1"),(AL1:A L999)) and it highlights the first ":" between BR1 and BR999 and says "Expected: )" ~sigh~ "Bob Phillips" wrote: There is a bracket misisng at the end = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:A L999)) or even = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");AL1:AL 999) should work, assuming that you have a Continental version of Excel that uses ; \(semi-coln) as a separator, not , (comma) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "StephanieH" wrote in message ... I need to sum column AL IF column BR = "Y" AND column BJ = "S1". Is this possible? I've tried: RiskShareCount = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:A L999) but I get Syntax Error. I'm also going to have to count the same records. Is this possible? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif SumProduct Several Criteria
Stephanie,
I just plugged that comma based version into my spreadsheet and got no error. No answer as I have no data, but it parsed fine. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "StephanieH" wrote in message ... No, it's not a Continental version. I'd picked that up from another posting (doing my homework before I ask ; - ) I just tried: MyTotal = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:A L999)) and got a Syntax error. So I tried: MyTotal = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1"),(AL1:A L999)) and it highlights the first ":" between BR1 and BR999 and says "Expected: )" ~sigh~ "Bob Phillips" wrote: There is a bracket misisng at the end = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:A L999)) or even = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");AL1:AL 999) should work, assuming that you have a Continental version of Excel that uses ; \(semi-coln) as a separator, not , (comma) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "StephanieH" wrote in message ... I need to sum column AL IF column BR = "Y" AND column BJ = "S1". Is this possible? I've tried: RiskShareCount = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:A L999) but I get Syntax Error. I'm also going to have to count the same records. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Awkward sumif/sumproduct with three criteria over two ranges | Excel Worksheet Functions | |||
Sumproduct (Sumif) with Nested Or Criteria | Excel Worksheet Functions | |||
date criteria with SUMIF or SUMPRODUCT | Excel Programming | |||
SUMIF/SUMPRODUCT/IF - 2 criteria - Date and Text | Excel Discussion (Misc queries) | |||
sumif or sumproduct with date as criteria | Excel Programming |