Try:
copied down and across... although it looks like you have inconsistent QTY fields, so not sure what's going on there....![]()
=(SUMPRODUCT((INDEX(Table_Query_from_MS_Access_Database5,0,3)=L$2)*1,(INDEX(Table_Query_from_MS_Access_Database5,0,2)=L$3)*1,(INDEX(Table_Query_from_MS_Access_Database5,0,8)=$I$8)*1,INDEX(Table_Query_from_MS_Access_Database5,0,ROWS($A$1:$A11)))*$I$2)
![]()
Bookmarks