Results 1 to 5 of 5

Countif & sumif combined required to solve answer - please help

Threaded View

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    Sydney,Australia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Countif & sumif combined required to solve answer - please help

    Hi Guys,

    Need help please!

    See attached file, "Test" and the below example;

    I need a formula that will do the following;

    Count the number of Basic Charges (in column E = yellow) that are sent on the same date (in column F = purple) to the same post code (in column T = blue) and provide an adjustment (in column AB = orange) for the sum of the Basic Charges that match this criteria less the lowest Basic Charge within the same criteria.

    For example;

    Let's assume the below are sent to the same post code on the same date;

    Basic1 = $5
    Basic2 = $10
    Basic3 = $15

    The adjustment would be the sum of Basic1, Basic2 & Basic3 = $30 - the lowest Basic Charge (Basic1) = $5
    Adjustment = $30 - $5 = $25

    $25 is the answer

    This is known as a consolidation adjustment where the client is to pay for the lowest Basic Charge and be credited for all other Basic Charges sent to the same post code on the same date.

    I have sorted the attached file in date and post code order. Can you please assume this sort is not done when you are providing your formula solution. It would be preferable to have the formula without sorting first. If you can only provide the formula by sorting the above first please advise that in your answer.

    Please supply the formula below to be entered into column AB (orange) on the attached file, "Test".

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIF and VLOOKUPS Combined May be the Answer?
    By RachV in forum Excel General
    Replies: 1
    Last Post: 02-07-2012, 12:54 PM
  2. Excel code required to solve puzzle
    By vasant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2011, 04:25 AM
  3. Help required to solve rounding problem with macro
    By sarath25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2011, 05:36 AM
  4. Required answer
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2009, 11:27 PM
  5. Help required to solve a linear equation through excel
    By souravroy1@rediffmail.com in forum Excel General
    Replies: 1
    Last Post: 08-19-2006, 08:20 PM

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