Ecel

Hi Dawn

Thanks for clarifying. I've had a go at constructing your worksheet based on your description, and attached a possible solution.

Column C of the inventory sheet contains the COUNTIF function. It looks like:

=COUNTIF(range, criteria)

First you tell it which cells to look at, then which cells to count. Any that it matches an "item code" for is counted. You didn't include a column like this in your question but it's the simplest way something like this would work.

As a bonus, you can have a look at the Stock Pick 2 sheet. Column C has a drop-down list to pick from to make life easier. You can see how this work by going to Data > Data Validation. The List feature allows you to pick from a list of options.

I hope this helps, let me know how you get on.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector