Hi, I really hope someone can help me solve this problem because it is driving me mad. I got it to work in a different workbook but now its not summing properly.
My formula is as follows: =IFERROR(VLOOKUP($B20,$J$11:$O$45,HLOOKUP(CONCATENATE($K$6,$D$10),$L$1:$O$2,2,FALSE),FALSE),SUMPRODUCT(($B$11:$B$36="Other")*($L$11:$L$36))+SUMPRODUCT(($B$11:$B$36="")*($L$11:$L$36)))
it is giving me a result of $39,680 but it should be giving me $40,073. I am attaching an example.
Thanks in advance for your help.![]()
Bookmarks