I have some two initial data columns Column A has the date in 1-1-12 format. Column B has a drop down option in each column the user can select large or small. I then have more columns across the top with the months listed and below them I use this sumproduct formula (SUMPRODUCT(--(A2:A16538<>""),--(MONTH(A2:A16538)=1))) to have excel look at the date and sum the total amount of products shipped in that month. But I want to add to that formula so it will further breakdown the data by large or small size.

I attached a sample excel sheet below so it is easier to see. I know I need to add or have another sum product formula that will look like =SUMPRODUCT(($A$2:$A$13=$E2)*($B$2:$B$13=G$9)). I just cannot seem to get it to cooperate. Yes, I know a pivot table may be easier but for the amount of data and updating I have a formula will work a lot easier. Thank you for any help you can provide!Excel_Forum_PP.xls