Hello

can I PLEASE get some help- I have a list of inventory:

Item qty
apples *formula [=countif(sheet2!a:a,A1) - where A1 is eual
to apples]
oranges * same
Pears * same

in sheet 2

oranges
apples
pears
bananas
kiwi
apples
oranges
etc. etc. (arox 500 items)

i need a formula or a method to "List" (i assume accross several cells) the
items in sheet2 that do not equal or match the inventory items in sheet 1
ie. kiwi and bananas and then count them

Thank you in Advance
--
j.t