I have an e-commerce site, and my backend service (shopify) exports my orders into an excel format.
I'm trying to add up the quantities of items sold in a particular state (TX). SUMIF formula seems like the straightforward solution, but the problem I'm running into is that for orders with multiple items, the state only appears once per order number.
So in the example, the highlighted section is one order (order #1647). The person ordered 3 items, and lives in TX. I want to add these up, but the state only appears in the first row of that order.
How can I adjust the formula to add up all the items from a certain state?
Thanks in advance.
Bookmarks