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?

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?

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?

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?