Suppose your data is in range A1:C10, column A dates, B product, C
quantity. Do the following.

Lets start from cell G1. Enter the first date's month's 1 day. For e.g.
you are starting from jun, enter 1-jun-05, then H1 enter 1-jul-05, and
so on till the last month you want evaluated. Format this row as mmm to
display only the months.

cells F2, F3, F4 should have a, b, c... your products.

In G2, enter the formula:
=SUMPRODUCT(--(MONTH($A$1:$A$10)=MONTH(G$1)),--($B$1:$B$10=$F2),$C$1:$C$10)

and copy across the length and breadth of the table


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=380043