Sumif SumProduct Several Criteria

[Guest]

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:AL999)
but I get Syntax Error.

I'm also going to have to count the same records. Is this possible?

 

[Bob Phillips]

There is a bracket misisng at the end

= SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");(AL1:AL999))

or even

= SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1");AL1:AL999)

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)

 

[Guest]

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:AL999))
and got a Syntax error.
So I tried:
MyTotal = SUMPRODUCT((BR1:BR999="Y")*(BJ1:BJ999="S1"),(AL1:AL999))
and it highlights the first ":" between BR1 and BR999 and says "Expected: )"

~sigh~

 

[Bob Phillips]

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)