1. I

    Sumifs?? Left?? Dish sales

    I'd like to sum all of the dish sales based on the Location number and Product IDs. Can I do this without creating a helper column? <colgroup><col><col><col span="2"><col></colgroup><tbody> A B C D 1 Location Product ID Product Desc Sales 2 555652 Houston 10047108 Dish 12" 4 3 555652...
  2. B

    Formula help needed

    So, I have a several locations. Lets say Phoenix, Goodyear, Avondale. For each location, they could have a number; 1, 2, 3, 4, or 5. Keep in mind, the location and numbers can be listed multiple times on this sheet. So what I need is, for the Location of Phoenix, what is the total amount for...

Some videos you may like

This Week's Hot Topics