Creating a count based off two fields
I am a complete novice at filemaker so forgive me if I am a little unclear. I am creating an office inventory system with individual records for each item. What I would like is a box showing the current number of that item we have in the office. Location is determined by a dropdown box which also contains the location name Office - Faulty. I would like only to count records which have the same name as the current record being browsed and have the location as Office omitting office -faulty - essentially creating a box which automatically updates to show current number of that item in stock which are usable.
Is this possible? I don't really know where to start.