Spreadsheet: 843711d1695507230-need-formula-to-calculate-average-gross-profit-margin-including-0-samples-margin-report
Sheet: Sheet1

Account | Sales Rep | Quantity | Unit Price | Total | DA Amount | DA Total | FOB Price | Total Cost | Margin | Gross Profit % | Margin w/DA | Gross Profit w/DA
Samples - Jillian Sanders | [NAME] | 1 | 17.99 | 0 |  |  | 12.5 | 12.5 | -12.5 | 0
Samples - Jillian Sanders | [NAME] | 1 | 13.99 | 0 | 0.71 | 0.71 | 9.29 | 9.29 | -9.29 | 0
Neighborly Public House | [NAME] | 24 | 14.99 | 359.76 | 1.5 | 36 | 11.5 | 276 | 83.76 | 0.2328218812541694
Samples - Jillian Sanders | [NAME] | 1 | 10.99 | 0 |  |  | 7 | 7 | -7 | 0
Silverleaf Country Club | [NAME] | 36 | 10.99 | 395.64 |  |  | 7 | 252 | 143.64 | 0.3630573248407643
Samples - Jillian Sanders | [NAME] | 1 | 10.99 | 0 |  |  | 6.35 | 6.35 | -6.35 | 0
Samples - Jillian Sanders | [NAME] | 1 | 22.99 | 0 |  |  | 15 | 15 | -15 | 0
Samples - Jillian Sanders | [NAME] | 1 | 12.99 | 0 |  |  | 8.75 | 8.75 | -8.75 | 0
Samples - Jillian Sanders | [NAME] | 1 | 12.99 | 0 |  |  | 8.75 | 8.75 | -8.75 | 0
Brix Wines (Cave Creek) | [NAME] | 6 | 60 | 360 |  |  | 40 | 240 | 120 | 0.3333333333333333
Brix Wines (Cave Creek) | [NAME] | 6 | 60 | 360 |  |  | 40 | 240 | 120 | 0.3333333333333333
Silverleaf Country Club | [NAME] | 24 | 21 | 504 |  |  | 15 | 360 | 144 | 0.2857142857142857
Silverleaf Country Club | [NAME] | 6 | 56 | 336 |  |  | 38 | 228 | 108 | 0.3214285714285715
Samples - Jillian Sanders | [NAME] | 1 | 11.99 | 0 |  |  | 7.66 | 7.66 | -7.66 | 0
Grapeables | [NAME] | 12 | 7.99 | 95.88 |  |  | 4.92 | 59.04 | 36.84 | 0.3842302878598248
Grapeables | [NAME] | 12 | 26 | 312 |  |  | 17 | 204 | 108 | 0.3461538461538461
Grapeables | [NAME] | 6 | 15.99 | 95.94 |  |  | 9.87 | 59.22 | 36.72 | 0.3827392120075047
Samples - Jillian Sanders | [NAME] | 1 | 10.99 | 0 |  |  | 6.67 | 6.67 | -6.67 | 0
[NAME] | [NAME] | 12 | 9.99 | 119.88 |  |  | 6.58 | 78.96 | 40.92 | 0.3413413413413414
[NAME] | [NAME] | 12 | 8.99 | 107.88 |  |  | 6.17 | 74.04 | 33.84 | 0.3136818687430478
[NAME] | [NAME] | 12 | 15.99 | 191.88 |  |  | 11 | 132 | 59.88 | 0.3120700437773609
[NAME] | [NAME] | 12 | 11.99 | 143.88 |  |  | 7.67 | 92.04 | 51.84 | 0.3603002502085071
Spiga Cucina Italiana | [NAME] | 12 | 11.99 | 143.88 |  |  | 7.5 | 90 | 53.88 | 0.3744787322768974
[NAME] | [NAME] | 2 | 18.5 | 37 |  |  | 11.2 | 22.4 | 14.6 | 0.3945945945945946
Silverleaf Country Club | [NAME] | 24 | 9.99 | 239.76 | 0.83 | 19.92 | 7.08 | 169.92 | 69.84 | 0.2912912912912913
Silverleaf Country Club | [NAME] | 24 | 59 | 1416 |  |  | 40 | 960 | 456 | 0.3220338983050847
 | [NAME] Average
[NAME] (customer) | [NAME] | 3 | 36 | 108 |  |  | 28 | 84 | 24 | 0.2222222222222222
Espiritu | [NAME] | 3 | 36 | 108 |  |  | 28 | 84 | 24 | 0.2222222222222222
Welcome Diner (Phoenix) | [NAME] | 8 | 7.99 | 63.92 | 0.83 | 6.64 | 5.18 | 41.44 | 22.48 | 0.3516896120150187
Welcome Diner (Phoenix) | [NAME] | 9 | 7.99 | 71.91 | 0.83 | 7.47 | 5.18 | 46.62 | 25.29 | 0.3516896120150187
Welcome Diner (Phoenix) | [NAME] | 5 | 7.99 | 39.95 | 0.83 | 4.15 | 5.18 | 25.9 | 14.05 | 0.3516896120150187
Welcome Diner (Phoenix) | [NAME] | 1 | 9.99 | 9.99 |  |  | 6.67 | 6.67 | 3.32 | 0.3323323323323323
Welcome Diner (Phoenix) | [NAME] | 1 | 9.99 | 9.99 |  |  | 6.67 | 6.67 | 3.32 | 0.3323323323323323
Welcome Diner (Phoenix) | [NAME] | 1 | 12.99 | 12.99 |  |  | 8.75 | 8.75 | 4.24 | 0.3264049268668207
Welcome Diner (Phoenix) | [NAME] | 2 | 12.5 | 25 |  |  | 7.49 | 14.98 | 10.02 | 0.4008
Welcome Diner (Phoenix) | [NAME] | 5 | 12.5 | 62.5 |  |  | 7.49 | 37.45 | 25.05 | 0.4008
Welcome Diner (Phoenix) | [NAME] | 1 | 10.99 | 10.99 |  |  | 7.08 | 7.08 | 3.91 | 0.3557779799818017
Welcome Diner (Phoenix) | [NAME] | 1 | 10.99 | 10.99 |  |  | 7.08 | 7.08 | 3.91 | 0.3557779799818017
Welcome Diner (Phoenix) | [NAME] | 1 | 10.99 | 10.99 |  |  | 7.08 | 7.08 | 3.91 | 0.3557779799818017
Samples - Kapono Rowe | [NAME] | 1 | 0 | 0 |  |  | 21.7 | 21.7 | -21.7 | 0
Welcome Diner (Phoenix) | [NAME] | 1 | 12.99 | 12.99 |  |  | 8.75 | 8.75 | 4.24 | 0.3264049268668207
Samples - Kapono Rowe | [NAME] | 1 | 0 | 0 |  |  | 18.69 | 18.69 | -18.69 | 0
 | [NAME] Average