# sumproduct muitiple criteria with greater than function

1. ## sumproduct muitiple criteria with greater than function

I am using a sumproduct formula with multiple criteria. I want the formula to return the sum total of values greater than a specific number. I believe my return is giving me the count vs he sum total. Where am I going wrong with my formula?

enicMF
----B----------C------------D-------------F-------Result
--0001-------CF-------New Jersey-----160-----700000
--0001-------CF-------New York-------160-------0---

Q111301B
----A----------J------------D-------------F---------G---
--0001-------CF-------New Jersey-----160-----300000
--0001-------CF-------New Jersey-----160-----400000
--0001-------CF-------New York-------160------200000
--0001-------CF-------New York-------160------150000

My formula is:

=SUMPRODUCT((Q111301B!\$A\$2:\$A\$18296=enicMF!B532)*(Q111301B!\$J\$2:\$J\$18296=enicMF!C532)*(Q111301B!\$D\$2:\$D\$18296=enicMF!D532)*(Q111301B!\$F\$2:\$F\$18296+0=enicMF!F532)*(Q111301B!\$G\$2:\$G\$18296>500000))

Where is I going wrong?

2. ## Re: sumproduct muitiple criteria with greater than function

Try this:
Please Login or Register  to view this content.

3. ## Re: sumproduct muitiple criteria with greater than function

You'd need something like:

Formula:
Please Login or Register  to view this content.

Regards, TMS

4. ## Re: sumproduct muitiple criteria with greater than function

That formula correction worked in picking up values greater than 500000 but how can I fix my formula where I want to add all the values that meet my criteria and only give me the total if the value is greater than 500000. I'm hoping it's only a minor correction

5. ## Re: sumproduct muitiple criteria with greater than function

Try this:
Please Login or Register  to view this content.
Let me know if you have any questions.

6. ## Re: sumproduct muitiple criteria with greater than function

JeteMc thank you so much. You are absolutely awesome!!

7. ## Re: sumproduct muitiple criteria with greater than function

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. Hope that you have a good day.

#### Thread Information

##### 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