In cell H8, create a formula using the DCOUNT function to count the number of tours priced under $2,000, using the range A1:E22 as the database, “Price” as the field, and the range G6:G7 as the criteria.

Tour Code	Tour	Depart Date	Price	Seats Reserved		Tour Information
758H	Pacific Odyssey	1/12/2018	$   2,255	20		Tour Code	966W
120A	Amazing Amazon	1/13/2018	$   2,466	18		Tour
431V	Amazing Amazon	2/22/2018	$   2,134	15		Depart Date
762N	Hiking Patagonia	2/28/2018	$   2,812	15
215C	Pearls of the Orient	3/13/2018	$   2,350	15		Price
251D	Silk Road Travels	3/19/2018	$   2,110	19		< 2000
966W	Photographing France	3/20/2018	$   1,755	20		Number of Tours
830L	Old Japan	3/23/2018	$   2,450	22
245M	African National Parks	4/8/2018	$   3,115	10
334Q	Experience Cambodia	4/11/2018	$   2,441	21		Tour
325B	Biking in France	4/15/2018	$   1,900	19		Amazing Amazon
754Q	Amazing Amazon	4/23/2018	$   1,925	20		Average Price
543Y	Catalonia Adventure	5/9/2018	$   2,587	17
556J	Treasures of Ethiopia	5/18/2018	$   1,638	5
675Y	Monasteries of Bulgaria	5/20/2018	$   1,663	11
544T	Biking in France	5/23/2018	$   1,635	10
778W	Magnificent Montenegro	5/27/2018	$   1,890	4
446R	Catalonia Adventure	6/9/2018	$   2,100	15
677Y	Nepal Trekking	6/9/2018	$   4,200	18
433Q	Corfu Sailing Voyage	6/10/2018	$   2,190	10
335V	Amazing Amazon	8/23/2018	$   2,877	18

Answer rating: 100% (QA)

formula by using DCOUNT function to Count the number of ... View the full answer