42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 Small Medium Medium Small Big Small Small Small Small Small Small Small Small Medium Medium Medium Medium Medium Small Medium Big $ 8,237.85 $ 48.30 $ 6,221.25 $ 414.88 $ 5,401.24 $ 877.97 $ 10,013.81 $ 807.85 $ 8,466.70 $ 450.57 $ 8,382.21 $ 958.25 $ 8,105.42 $ 647.65 $ 10,051.26 $ 1,003.73 $ 3,667.20 $ 680.71 $ 7,822.06 $ 924.36 4,575.53 $ 657.65 $ 3,178.20 $ 756.21 $ 1,734.41 $ 864.15 $ 8,601.07 $ 666.92 $ 8,328.45 $ 898.71 $ 9,715.27 $ 536.26 $ 4,722.77 $ 837.71 3,434.69 $ 574.12 $ 8,696.76 $ 581.44 $ 9,195.08 $ 1,000.67 $ 4,168.87 $ 650.90 $ 885.24 $ 323.98 Big A B D E G H J Exercise 5 Sum Revenue 1 2 3 4 SUMIF Function Group Segment Big Medium Small Using SUMIF, create the same table as Exercise 2 (Show Revenue By Group Segment) in two steps. 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Group Segment Medium Medium Small Medium Small Small Small Medium Big Medium Big Small Big Small Small Small Big Small Small Medium Big Medium Revenue Expenses S 8,249.33 $ 594.88 $ 6,557.87 $ 83.34 $ 6,180.04 $ 551.27 $ 9,915.45 $ 336.86 $ 4,047.67 $ 481.01 $ 4,797.09 $ 962.36 $ 6,537.80 $ 931.97 $ 3,151.42 $ 848.21 $ 9,504.78 $ 827.56 $ 9,378.14 $ 566.80 $ 6,772.13 $ 436.88 $ 1,854.63 $ 930.55 $ 8,303.94 $ 680.75 $ 6,741.46 $ 418.03 $ 4.151.44 $ 336.41 $ 7,972.30 $ 917.14 $ 10,331.58 $ 440.47 $ 3,695.19 $ 217.66 $ 7,904.29 $ 764.58 $ 849.26 $ 94.52 $ 7,157.63 $ 915.92 $ 3,712.57 $ 432.55 23 24 25 26 27 28 29 30 31 32 83 34 35 36 37 88 39 40 41 12 13 14 15 Medium Small Small Big Medium Medium Big Small Small Big Small Medium Medium Small Medium Medium Small Small Small Small Medium Medium Small $ 3,712.57 $ 432.55 $ 7,596.44 $ 134.82 $ 2,198.66 $ 1,037.29 $ 4,724.00 $ 463.29 $ 1,331.26 $ 959.23 $ 2,743.80 $ 222.92 $ 5,038.31 $ 306.96 $ 10,458.27 $ 692.76 $ 7,567.04 $ 720.32 $ 7,688.43 $ 851.85 $ 4,023.23 $ 166.49 $ 4,551.60 $ 701.05 $ 2,665.11 $ 654.98 $ 6,589.12 $ 278.19 $ 5,220.43 $ 589.17 $ 7,282.19 $ 387.55 $ 6,444.58 $ 258.50 $ 10,299.03 $ 287.80 $ 9,841.23 $ 824.48 $ 8,237.85 $ 48.30 $ 6,221.25 $ 414.88 $ 5,401.24 $ 877.97 $ 10,013.81 $ 807.85 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 Small Small Small Small Small Small Small Small Medium Medium Medium Medium Medium Small Medium Big Big Medium Small Small Small Small Small $ 8,382.21 $ 958.25 $ 8,105.42 $ 647.65 $ 10,051.26 $ 1,003.73 3,667.20 $ 680.71 $ 7,822.06 $ 924.36 $ 4,575.53 $ 657.65 3,178.20 $ 756.21 $ 1,734.41 $ 864.15 $ 8,601.07 $ 666.92 8,328.45 $ 898.71 $ 9,715.27 $ 536.26 $ 4,722.77 $ 837.71 3,434.69 $ 574.12 8,696.76 $ 581.44 9,195.08 $ 1,000.67 4,168.87 $ 650.90 885.24 $ 323.98 3,222.21 $ 760.28 3,185.18 $ 455.46 5,050.98 $ 618.33 306.08 $ 275.31 9,598.98 $ 613.29 $ 10,338.80 $ 979.85 A A A A A A A A A A B C D E F G H 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 Medium Small Small Big Big Medium Small Small Small Big Big Small Small Small Small Small Big Medium Medium Big Small Small Medium $ 7,350.61 $ 271.99 $ 7,506.47 $ 408.01 $ 1,939.78 $ 413.94 $ 7,692.22 $ 1,015.87 $ 1,060.49 $ 607.34 $ 738.51 $ 431.47 $ 8,174.84 $ 206.65 $ 4,368.81 $ 203.38 $ 1,292.52 $ 123.11 $ 2,210.75 $ 465.53 $ 4,240.74 $ 737.07 $ 5,927.04 $ 501.24 $ 2,597.35 $ 489.99 $ 9,549.49 $ 835.02 $ 3,931.33 $ 191.42 $ 8,578.80 $ 670.24 $ 1,946.14 $ 273.51 $ 9,021.02 $ 402.06 $ 5,575.67 $ 148.33 $ 1,193.07 $ 148.13 $ 10,340.53 $ 250.08 $ 5,512.77 $ 542.62 $ 2,556.00 824.13 14 X fx A B D E F G H IZ 23 94 25 96 viedium Small Medium Big Medium Medium Small Medium Small $ 2,550.00 $ $ 10,157.81 $ $ 8,921.52 $ $ 10,494.44 $ $ 7,007.77 $ $ 4,811.04 $ $ 8,657.83 $ $ 8,204.32 $ $ 4,246.88 $ 824.13 508.17 259.33 565.43 765.69 193.17 171.60 278.75 644.52 97 28 29 00 01 A A A 02 03 04