Answer the following using excel. What formulas do you use to COUNTIF, COUNTIFS, INDEX, MATCH, or other logic functions"

CustName	Number of Orders	# Order Used UPS Trade Direcct	# OrderUsed Frieght	# Order Used Express Critical	Sales total Using UPS Trade Direcct	Sales Total Using Frieght	Sales Total Using Express Critical	Most # order used UPS Trade Direcct	UPS Trade Direcct has the largest sales total
Bigmart
Cool Threads

Use this table to create formjulas to answer the above:

Type	TransactionNumber	CustNum	CustName	TransactionDate	Amount	InvoiceDate	ShipDate	Shipping method
Sales	1001	1836	Runner's Market	5-Mar-15	$ 16,157.44	5-Mar-15	5-Mar-15	UPS Trade Direct
Sales	1002	1168	Bigmart	5-Mar-15	$ 9,144.00	5-Mar-15	5-Mar-15	UPS Frieght
Sales	1003	1167	Goodway	5-Mar-15	$ 15,737.60	5-Mar-15	5-Mar-15	UPS Express Critical
Sales	1004	1841	Neighborhood Athletic Supply	8-Mar-15	$ 6,008.00	8-Mar-15	8-Mar-15	UPS Trade Direct
Sales	1005	1842	Northern Lites	8-Mar-15	$ 7,241.60	8-Mar-15	8-Mar-15	UPS Express Critical
Sales	1006	1168	Bigmart	13-Mar-15	$ 8,476.00	13-Mar-15	13-Mar-15	UPS Trade Direct