Hello Everyone,
Just wondering if I can get some help with a formula. I am trying to work the total amount spent per carrier over a month, 3 months, 6 months and 12 months. From A1 to E53 is a report generated by admin and shows the Sender - A, the pick up suburb - B, the delivery suburb - C, the pick up cost - D and the delivery cost - E. Almost always is the pickup and delivery completed by a different carrier.
So I would like the formula to tell me how much I spend with each carrier.
I have attached file for you to get a better understanding of what I am after.
Thanks for you help.
Bookmarks