# 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

2. You could use

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

3. One way

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

VBA Noob

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

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.

6. Here is an overview of the Sumproduct function:

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1