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?
Bookmarks