Order Date | Type | Order Status | Cost | |
2019-07-01 | Bulk | Completed | $5 | |
2019-07-09 | Parcel | Shipped | $7 |
<tbody>
</tbody>
I need to figure out the weekly shipping costs for Parcel packages. At the moment I'm doing it manually because I can't figure out how to write a sumif statement with a range of dates.
This sheet has about 100K rows, so it's quite extensive. I want to see everything for 7 days, week ending Sun, that is Type = Parcel, Order Status = Completed, and I want the total Cost for that.
Can anyone advise?
Thanks!