Just show me the formula, please.

1. Calculate the number of vendors that sell Kiwis. Create your formula.

2. Calculate Total Sales dollars, excluding the two highest and two lowest amounts. Create your formula.

3. Calculate total Cases Sold (all types of fruit) by vendors with "Fruit" included in their name. Create your formula.

4. Calculate Total Sales dollars for Atlanta and Macon combined. Create your formula.

5. Calculate the total Cases Sold of Apples by the North GA region. Create your formula.

A B D E F 1 RegID Region CityID City Vendorld Vendor 2 0010 North GA 0100 Atlanta 00100 Fruit RUS 3 0010 North GA 0100 Atlanta 00100 Fruit RUS 4 0010 North GA 0100 Atlanta 00100 Fruit R Us 5 0010 North GA 0100 Atlanta 00100 Fruit R Us 6 0010 North GA 0100 Atlanta 00100 Fruit R Us 7 0010 North GA 0100 Atlanta 00200 Bob's Fruit 8 0010 North GA 0100 Atlanta 00200 Bob's Fruit 9 0010 North GA 0100 Atlanta 00200 Bob's Fruit 10 0010 North GA 0100 Atlanta 00200 Bob's Fruit 11 0010 North GA 0100 Atlanta 00200 Bob's Fruit 12 0010 North GA 0100 Atlanta 00300 Fruitju 13 0010 North GA 0100 Atlanta 00300 Fruitju 14 0010 North GA 0100 Atlanta 00300 Fruitju 15 0010 North GA 0100 Atlanta 00300 Fruitju 16 0010 North GA 0100 Atlanta 00300 Fruitju 17 0010 North GA 0100 Atlanta 00400 Orange U Glad 18 0010 North GA 0100 Atlanta 00400 Orange U Glad 19 0010 North GA 0100 Atlanta 00400 Orange U Glad 20 0010 North GA 0100 Atlanta 00400 Orange U Glad 21 0010 North GA 0100 Atlanta 00400 Orange U Glad 22 0010 North GA 0200 Blue Ridge 00500 Mountain Fruit 23 0010 North GA 0200 Blue Ridge 00500 Mountain Fruit 24 0010 North GA 0200 Blue Ridge 00500 Mountain Fruit 25 0010 North GA 0200 Blue Ridge 00500 Mountain Fruit 26 0010 North GA 0200 Blue Ridge 00500 Mountain Fruit 27 0010 North GA 0300 Clarkesville 00600 Fruit Direct G H 1 J Item ID Product Cases Sold Total Sales 100 Oranges 6168 $61,680 200 Apples 6079 $85,106 300 Kiwis 6058 $66,638 400 Bananas 6868 $75,548 500 Mixed Berries 1996 $29,940 100 Oranges 7818 $93,816 200 Apples 1565 $21,910 300 Kiwis 9967 $99,6701 400 Bananas 9842 $98,420 500 Mixed Berries 8993 $89,930 100 Oranges 4933 $54,263 200 Apples 7704 $107,856 300 Kiwis 5519 $71,747 400 Bananas 8442 $126,630 500 Mixed Berries 889 $11,557 100 Oranges 6551 $72,061 200 Apples 2605 $31,260 300 Kiwis 3317 $43,121 400 Bananas 7411 $81,521 500 Mixed Berries 6227 $93,405 100 Oranges 6415 $89,810 200 Apples 6426 $83,538 300 Kiwis 8035 $112,490 400 Bananas 5075 $60,900 500 Mixed Berries 3064 $36,768 100 Oranges 686 $9,604 28 0010 North GA 0300 Clarkesville 00600 29 0010 North GA 0300 Clarkesville 00600 30 0010 North GA 0300 Clarkesville 00600 31 0010 North GA 0300 Clarkesville 00600 32 020 Mid GA 0400 Macon 00700 33 020 Mid GA 0400 Macon 00700 34 020 Mid GA 0400 Macon 00700 35 020 Mid GA 0400 Macon 00700 36 020 Mid GA 0400 Macon 00700 37 020 Mid GA 0400 Macon 00800 38 020 Mid GA 0400 Macon 00800 39 020 Mid GA 0400 Macon 00800 40 020 Mid GA 0400 Macon 00800 41 020 Mid GA 0400 Macon 00800 42 030 South GA 0500 Brunswick 00900 43 030 South GA 0500 Brunswick 00900 44 030 South GA 0500 Brunswick 00900 45 030 South GA 0500 Brunswick 00900 46 030 South GA 0500 Brunswick 00900 47 030 South GA 0600 Valdosta 01000 48 030 South GA 0600 Valdosta 01000 49 030 South GA 0600 Valdosta 01000 50 030 South GA 0600 Valdosta 01000 51 030 South GA 0600 Valdosta 01000 Fruit Direct 200 Fruit Direct 300 Fruit Direct 400 Fruit Direct 500 Middle Georgia Fruit 100 Middle Georgia Fruit 200 Middle Georgia Fruit 300 Middle Georgia Fruit 400 Middle Georgia Fruit 500 Whistlestop Fruit Stand 100 Whistlestop Fruit Stand 200 Whistlestop Fruit Stand 300 Whistlestop Fruit Stand 400 Whistlestop Fruit Stand 500 Navel Oranges & More 100 Navel Oranges & More 200 Navel Oranges & More 300 Navel Oranges & More 400 Navel Oranges & More 500 Oranges 'n Onions 100 Oranges 'n Onions 200 Oranges 'n Onions 300 Oranges 'n Onions 400 Oranges 'n Onions 500 Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries Oranges Apples Kiwis Bananas Mixed Berries 8203 $82,030 3920 $58,800 8262 $107,406 4251 $51,012 5469 $71,097 1126 $15,764 3064 $45,960 1473 $14,730 4406 $48,466 9983 $149,745 8319 $108,147 6850 $68,500 7994 $87,934 7404 $81,444 5591 $61,501 1481 $17,772 5879 $64,669 1561 $23,415 5668 $68,016 5240 $52,400 4728 $61,464 1062 $11,682 6165 $80,145 835 $8,350