Thanks Bob

I think I might have misled you with the term month i have the following:

A B
Code Qty
5 10
7 1
14 2
23 3
34 4
45 7
5 6
14 12

I need a formula that will calculate the amount of times the code number
appears in column A and the qty of that code number used.

Thanks


"Bob Phillips" wrote:

=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