Write your own criteria
In this exercise we will complete the Criteria Table ourselves, based on the requirements.
As a reminder, below we display the syntax of one of these database functions, DCOUNT( ) and a brief recap on Criteria Table:
Our criteria for this exercise: Order Item IDs with Sales > $1000 in California.
This exercise is part of the course
Advanced Excel Functions
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise