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