Hi, this is not exactly what you intended with the colours but the idea
remains the same. You've got your products separated according to your
key (day<10).
Days10 = IF(days<10,0,1)
Sum of qty mth
days10 prod 1 2 3 4 5 6 7 8 Grand Total
0 2589 34 34
0 Total 34 34
1 1234 24 89 72 185
2345 180 180
2589 34 56 16 106
4759 65 65 130
9586 170 170
1 Total 204 170 65 34 121 89 16 72 771
Grand Total 204 170 99 34 121 89 16 72 805
HTH,
Tomek Polak,
http://vba.blog.onet.pl