You're welcome.
The -- (double unary minuses) work in much the same way as the * in your
formula. They each cause the sumproduct to resolve True and False answers
into 1's and 0's. It comes down do a matter of preference which you use so
your formula could be:
=SUMPRODUCT(--(B2:B1322=9),--(E2:E13225),--(E2:E1322<=10))
More info on sumproduct at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Regards
Rowan
"Cybertech" wrote:
Thanks Bernie & Rowan!
I had found the answer a few minutes ago after searching the forums for
the last hour and am using:
=COUNTIF(E:E,"5")-COUNTIF(E:E,"10") which works! I had been using AND
before and learned you can't with COUNTIF.
I also expanded on Rowan's second suggestion and am using:
=SUMPRODUCT((B2:B1322=9)*(E2:E13225)*(E2:E1322<=1 0))
in another area. I couldn't get it to work with the "--" part (and I'm
not sure what it does) but when I removed it everything is working
correctly.
Thanks Again
--
Cybertech
------------------------------------------------------------------------
Cybertech's Profile: http://www.excelforum.com/member.php...o&userid=26533
View this thread: http://www.excelforum.com/showthread...hreadid=398428