# Sumproduct or array formula for counting criteria of sum of cells

1. ## 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  Register To Reply

2. You could use

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

3. One way

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

VBA Noob  Register To Reply

4. Well, I guess I should have figured that one out. Thanks!   Register To Reply

5. 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.  Register To Reply

6. Here is an overview of the Sumproduct function:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html  Register To Reply