Hi,

Put this in a cell and drag rown for 12 rows to get the total for each month

=SUMPRODUCT((MONTH($A$1:$A$20)=ROW(A1))*($B$1:$B$2 0))

Mike

"Blue Fish" wrote:

Hello:

I have the excel that it will record down how many items sold out.
May I know how can I calculate how much items has been sold out by every
month?

Thanks a lot!

Date Items Sold Out
1-Oct-2008 2
30-Oct-2008 3
4-Nov-2008 4
3-Mar-2008 6
2-Feb-2008 5
6-Nov-2008 12
6-Mar-2008 16