+ Reply to Thread
Results 1 to 4 of 4

SUM fuction after sorting.. Help (easy)

  1. #1
    Registered User
    Join Date
    01-29-2013
    Location
    Cyprus
    MS-Off Ver
    Excel 365
    Posts
    9

    SUM fuction after sorting.. Help (easy)

    Hey guys... First post here..

    I have a simple problem..
    I have four columns

    Issued Date Value Date Company's Name Amount

    03.09.2012 29.12.2012 AAAAAA € 750.00
    27.12.2012 04.01.2013 BBBBBB € 7,020.00
    27.12.2012 04.01.2013 CCCCCC € 11,700.00
    27.12.2012 04.01.2013 DDDDD € 1,000.00
    27.12.2012 07.01.2013 EEEEEEE € 274.95
    28.12.2012 08.01.2013 FFFFFFF € 327.60
    29.12.2012 09.01.2013 GGGGGG € 500.00
    13.12.2012 12.01.2013 11111111 € 400.00
    10.12.2012 14.01.2013 22222222 € 430.00
    03.09.2012 15.01.2013 33333333 € 500.00
    03.09.2012 15.02.2013 44444444 € 600.00
    25.09.0212 18.01.2013 555555555 € 200.00
    08.11.2012 20.02.2013 777777777 € 500.00
    19.11.2012 20.03.2013 888888888 € 350.50
    19.11.2012 20.03.2013 999999999 € 150.00
    TOTAL 24.353.05
    Thats cheques
    As you can see now is sorter by valued date.
    Lets say for example that I want to subtract all the cheques that valued in January. My step is to create a formula that subtract the cheques that value in January from the total amount. But if I decide to sort the cheques by Issued date the numbers changes in the cells that I previously select and the amount that I want to subtract change. How can I ''lock'' the numbers so the fuction always follow those numbers instead of the cells?
    The real list is much longer by the way..
    I think it's easy guys..
    Anyway. Thanks in advance of any help...

    Edit: I dont know why everythin turn out like this but you guys still can understand I guess...
    Last edited by Mardem; 01-29-2013 at 11:16 AM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: SUM fuction after sorting.. Help (easy)

    Hi_Καλησπέρα Κουμπάρε!

    As you understand NOTHING is easy if you don't know how to do this.

    Looks to me like to need a SUM- aSUMPRODUCT...but i think we need a sample workbook to work on it.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: SUM fuction after sorting.. Help (easy)

    The numbers shouldn't change, the amount of a cheque should remain alongside the other details.

    To sort.
    Select the ENTIRE range
    Sort on whatever column you choose to sort on.

    Use this formula
    =SUMPRODUCT((MONTH(A1:A14)<>1)*(D1:D14))
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    01-29-2013
    Location
    Cyprus
    MS-Off Ver
    Excel 365
    Posts
    9

    Re: SUM fuction after sorting.. Help (easy)

    Γειά σου Φώτη...

    The problem is that I will have to often change between the Issued Date and Valued Date... I will check out the SUMPROODUCT
    function to see if I can do something..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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