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?
|