thanks, Aladin - I made the example simple for clarity - the reference to advertising has me flummoxed though......
Aladin - your sumproduct formula works perfectly, yet if I change it to MIN it returns 0, why is this, thanks.
Total Sales | Unit Cost | Total Cost | Profit | CustomerID | Customer |
$ 984.00 | $ 18.00 | $ 738.00 | $ 246.00 | 315 | The Station |
$ 1,350.00 | $ 14.00 | $ 1,260.00 | $ 90.00 | 315 | The Station |
$ 324.00 | $ 8.00 | $ 216.00 | $ 108.00 | 233 | Bert's Bistro |
$ 1,005.00 | $ 14.00 | $ 938.00 | $ 67.00 | 14 | Smoke House |
$ 948.00 | $ 6.00 | $ 474.00 | $ 474.00 | 572 | Flagstaff House |
$ 690.00 | $ 14.00 | $ 644.00 | $ 46.00 | 23 | Two Bitts |
$ 780.00 | $ 14.00 | $ 728.00 | $ 52.00 | 6 | Pierce Arrow |
$ 468.00 | $ 8.00 | $ 312.00 | $ 156.00 | 95 | Mamm'a Pasta Palace |
$ 990.00 | $ 14.00 | $ 924.00 | $ 66.00 | 846 | The Dandelion |
$ 870.00 | $ 14.00 | $ 812.00 | $ 58.00 | 557 | Carmens |
$ 1,320.00 | $ 28.00 | $ 1,120.00 | $ 200.00 | 315 | The Station |
$ 2,343.00 | $ 28.00 | $ 1,988.00 | $ 355.00 | 846 | The Dandelion |
$ 270.00 | $ 14.00 | $ 252.00 | $ 18.00 | 557 | Carmens |
$ 420.00 | $ 14.00 | $ 392.00 | $ 28.00 | 572 | Flagstaff House |
$ 1,749.00 | $ 35.00 | $ 1,155.00 | $ 594.00 | 14 | Smoke House |
$ 112.00 | $ 4.00 | $ 56.00 | $ 56.00 | 14 | Smoke House |
$ 576.00 | $ 4.00 | $ 288.00 | $ 288.00 | 95 | Mamm'a Pasta Palace |
$ 80.00 | $ 4.00 | $ 40.00 | $ 40.00 | 95 | Mamm'a Pasta Palace |
$ 630.00 | $ 14.00 | $ 588.00 | $ 42.00 | 14 | Smoke House |
$ 432.00 | $ 7.00 | $ 336.00 | $ 96.00 | 23 | Two Bitts |
$ 609.00 | $ 12.00 | $ 348.00 | $ 261.00 | 846 | The Dandelion |
$ 240.00 | $ 18.00 | $ 180.00 | $ 60.00 | 95 | Mamm'a Pasta Palace |
$ 1,176.00 | $ 6.00 | $ 588.00 | $ 588.00 | 23 | Two Bitts |
$ 1,080.00 | $ 18.00 | $ 810.00 | $ 270.00 | 557 | Carmens |
$ 870.00 | $ 14.00 | $ 812.00 | $ 58.00 | 23 | Two Bitts |
$ 528.00 | $ 4.00 | $ 264.00 | $ 264.00 | 572 | Flagstaff House |
$ 1,785.00 | $ 12.00 | $ 1,020.00 | $ 765.00 | 6 | Pierce Arrow |
$ 288.00 | $ 18.00 | $ 216.00 | $ 72.00 | 846 | The Dandelion |
$ 360.00 | $ 7.00 | $ 280.00 | $ 80.00 | 6 | Pierce Arrow |
[…]
How to find customer name with highest sales and the total