Sumproduct or array formula for counting criteria of sum of cells

I need to count the number of rows where the sum of 3 columns is > 0. So, something like this:

=COUNTIF(DB8:DB7964,">0")

But for the results of the sum of colums DB:DD. I can easily do this via a helper column, but is it possible without the helper column?

TIA

Jason

You could use

=SUMPRODUCT(--(DB8:DB7964+DC8:DC7964+DD8:DD7964>0))

Well, I guess I should have figured that one out. Thanks!

Originally Posted by VBA Noob

One way

=SUMPRODUCT(--(DB1:DB1000>0)*(DC1:DC1000>0)*(DD1:DD1000>0))

VBA Noob

Thanks VBA Noob, but that will not work for my scenario. For example, if DB8 is 9, DC8 is -9, and DD8 is 5, then the sum is > 0, which should be counted. Your formula will result in 0 in this case, since DC8 is < 0.

DDL's formula worked for me. Thanks for the help guys.

Here is an overview of the Sumproduct function:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html