+ Reply to Thread
Results 1 to 1 of 1

Formula for calculating multiple multiple values

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    Brisbane
    MS-Off Ver
    Excel for Mac 2011
    Posts
    0

    Formula for calculating multiple multiple values

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1