=SUMPRODUCT(--(YEAR(A2:A200)=2008),--(MONTH(A2:A200)=10),B2:B200)

for Oct 2008.

--
__________________________________
HTH

Bob

"wilksy" wrote in message
...
I have 2 columns, 1 contains an item code and the other the qty booked out
against that code number. The items are booked out during the day and
entered as they occur. I would like to enter a formula that calulates how
many times during a month that item code number occurs and what the total
qty
used in that month.

I am using the COUNTIF function but that will only give me the amount of
times a particular code number has been used.

Can anybody suggest a suitable formula.

Thanks