Lunacy4682
New Member
 Joined
 Jul 14, 2020
 Messages
 2
 Office Version

 365
 Platform

 Windows
Hello Team.
I have been using this forum to learn and find my dumb mistakes for years. Thanks for all your posts and my education.
Here is a problem that I can seem to figure out. Any help is MUCH appreciated.
I am using a Sumproduct to total up an array from a few lists :
Week Summary tab has this =(SUMPRODUCT((IMPORT!$L$2:$L$10000=$C$3)*(IMPORT!$D$2:$D$10000=$N10)*(IMPORT!$H$2:$H$10000=O$8)*IMPORT!$J$2:$K$10000))
Import Tab has this in the J & K columns =(IF(B3="","",(IF((E3*(VLOOKUP(B3,Key!$C$2:$G$200,4,FALSE)))=0,"",(E3*(VLOOKUP(B3,Key!$C$2:$G$200,4,FALSE)))))))
I know that if I remove the null value option from the import tab  (IF(B3="","",  that the formula works. I have also tried (IMPORT!$J$2:$K$10000<>"") as shown below. I can't seem to get the sumproduct to ignore the null value and I know I'm missing something simple...
Here is what I have tried. =(SUMPRODUCT((IMPORT!$L$2:$L$10000=$C$3)*(IMPORT!$D$2:$D$10000=$N10)*(IMPORT!$H$2:$H$10000=O$8)*IMPORT!$J$2:$K$10000,(IMPORT!$J$2:$K$10000<>"")))
I have been using this forum to learn and find my dumb mistakes for years. Thanks for all your posts and my education.
Here is a problem that I can seem to figure out. Any help is MUCH appreciated.
I am using a Sumproduct to total up an array from a few lists :
Week Summary tab has this =(SUMPRODUCT((IMPORT!$L$2:$L$10000=$C$3)*(IMPORT!$D$2:$D$10000=$N10)*(IMPORT!$H$2:$H$10000=O$8)*IMPORT!$J$2:$K$10000))
Import Tab has this in the J & K columns =(IF(B3="","",(IF((E3*(VLOOKUP(B3,Key!$C$2:$G$200,4,FALSE)))=0,"",(E3*(VLOOKUP(B3,Key!$C$2:$G$200,4,FALSE)))))))
I know that if I remove the null value option from the import tab  (IF(B3="","",  that the formula works. I have also tried (IMPORT!$J$2:$K$10000<>"") as shown below. I can't seem to get the sumproduct to ignore the null value and I know I'm missing something simple...
Here is what I have tried. =(SUMPRODUCT((IMPORT!$L$2:$L$10000=$C$3)*(IMPORT!$D$2:$D$10000=$N10)*(IMPORT!$H$2:$H$10000=O$8)*IMPORT!$J$2:$K$10000,(IMPORT!$J$2:$K$10000<>"")))