Closed Thread
Results 1 to 7 of 7

SUMPRODUCT equation

  1. #1
    Forum Contributor
    Join Date
    03-27-2013
    Location
    Dubai
    MS-Off Ver
    MS365 Version 2301
    Posts
    118

    SUMPRODUCT equation

    Please I need a help

    I have a different sheets from different supplier, and I want to sum the sold quantities from each supplier in a different sheet.

    So the sold qty in the total sheet will be the summary from supplier 1 to supplier 4 by each day

    sometimes, the items duplicated in the supplier sheet, and other times we make sort in the supplier sheet.

    So if we make sort from A to Z in supplier 1 and sort from Z to A IN supplier 2. the SUM from start to end will never gives me the right results
    Attached Files Attached Files

  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: SUMPRODUCT equation

    Don't waste the value time of forum members, posting duplicate threads.

    In this case the only that you can manage is to ignore you. Now and next time...

    http://www.excelforum.com/excel-form...-equation.html
    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 Contributor
    Join Date
    03-27-2013
    Location
    Dubai
    MS-Off Ver
    MS365 Version 2301
    Posts
    118

    Re: SUMPRODUCT equation

    Thanks a lot for helping me

    But I post a new thread, because I was waiting for you more than one hour, and my manager with shouting on me to finalize these sheet.

    And I replied to you twice, but you did not reply me

    Anyhow, thanks

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,610

    Re: SUMPRODUCT equation

    Need a quick answer ? -----> Pay sites !!! Ask your manager for funding

    Forum rules suggest waiting 24hrs before bumping

  5. #5
    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: SUMPRODUCT equation

    Quote Originally Posted by zeez36 View Post
    Thanks a lot for helping me

    But I post a new thread, because I was waiting for you more than one hour, and my manager with shouting on me to finalize these sheet.

    And I replied to you twice, but you did not reply me

    Anyhow, thanks
    So you were waiting a whole hour!!

    I think that you misunderstood something. This is not a paid site. It's a forum that volunteers selflessly offer their knowledge and time.

    Nobody is obliged to answer. And of course there is no restriction on when you respond.

    Have a nice day.

  6. #6
    Forum Contributor
    Join Date
    03-27-2013
    Location
    Dubai
    MS-Off Ver
    MS365 Version 2301
    Posts
    118

    Re: SUMPRODUCT equation

    I am so sorry for that.

    I wish you accept my apologize

    Have a wonderful day

  7. #7
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: SUMPRODUCT equation

    Thanks Fotis.

    zeez36,

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed 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