AB D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Territory Apples Bannanas Cherries Dates Figs Totals Sales Figures for ABC Corporation Units Sold Returns Net Units Sold Price per Unit Sales per Unit 150 10 140 $0.29 $40.60 200 16 184 $0.16 $29.44 176 12 164 $0.33 $54.12 57 4 53 $0.11 $5.83 48 1 47 $0.47 $22.09 631 43 588 Average Price per Unit of All Listed Territories: Average Sales per Unit of All Usted Territories: Average Price per Unit of all listed Territories: =AVERAGE(G4:G8) Average Sales per Unit of all listed Territories: =AVERAGE(G4:60) =AVERAGE(G5:69) =AVERAGE(G4"G8) =AVERAGE(G4+G8) H G F E D AB 1 2 3 4 5 Territory Apples Bannanas Cherries Dates Figs Totals Sales Figures for ABC Corporation Units Sold Returns Net Units Sold Price per Unit Sales per Unit 150 10 140 $0.29 $40.60 200 16 184 $0.16 $29.44 176 12 $0.33 $54.12 57 4 53 $0.11 $5.83 48 47 $0.47 $22.09 631 43 588 164 6 7 8 9 10 11 12 13 14 Average Price per Unit of All Usted Territories: Average Sales per Unit of All Listed Territories: Average Price per Unit of all listed Territories: =AVERAGE(G4:G8) Average Sales per Unit of all listed Territories: =AVERAGE(H4*H8) =AVERAGE(H4:H8) =AVERAGE(H4*H8) =AVERAGE(H5:H9) AVERAGE(H4+H8)