# Sumproduct with OR Logic

1. ## Sumproduct with OR Logic

Hello peoples!

I'm trying to count the number of rows in a dataset where column A is something, B is something, C is something, D is not something, D is not something else, and column E > 0 OR F is something but I just can't get the result I want.

My actual dataset is a staggering 294,000 rows and 46 columns so here's a simplified version:
``Please Login or Register  to view this content.``
I've tried SUMPRODUCT((A2:A9="C")*((B2:B9>0)+(C2:C9="Helped"))) but this seems to double count where both criteria are met instead of just once.

The output should be 6, not 7.

sumproduct or.xlsx

2. ## Re: Sumproduct with OR Logic

=SUMPRODUCT((A2:A9="C") * ((B2:B9<>0) + (C2:C9="Helped") > 0))

3. ## Re: Sumproduct with OR Logic

Thank you. If I ever have children, I'm naming them all after you.

4. ## Re: Sumproduct with OR Logic

You're welcome. Check with my daughters to avoid a namespace conflict.

5. ## Re: Sumproduct with OR Logic

Surely you jest?

6. ## Re: Sumproduct with OR Logic

First grandchild arrives in July.

7. ## Re: Sumproduct with OR Logic

congrats!!!

(you missed the reference to the movie, Airport...dont call me Shirley lol)

8. ## Re: Sumproduct with OR Logic

Airport? James Earl Jones, a thousand years ago?

9. ## Re: Sumproduct with OR Logic

hey now, shirely it wasnt even 500 years ago?

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