+ Reply to Thread
Results 1 to 4 of 4

Stock Movement for too many stores ?

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,123

    Stock Movement for too many stores ?

    Formula on b2 to drag write and down

    Raw data is on sheet1

    Taken just partial data , my original real data is 50,000 rows and stock items at 10,000 plus
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,123

    Re: Stock Movement for too many stores ?

    SUMIF formula without the branch I know , I don't know to link the store into the sumif

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,633

    Re: Stock Movement for too many stores ?

    B2=SUMPRODUCT((RAW!$A$2:$A$27=B$1)*(RAW!$C$2:$C$27=$A2)*(RAW!$I$2:$I$27))
    Please Login or Register  to view this content.
    Try this and copy across
    your profile shows as Excel 2010, but your attached excel file is 2003
    if you are using excel 2010 then you can use sumifs function instead of sumproduct, Sumproduct consumes more time for calculations
    =SUMIFS(RAW!$I$2:$I$27,RAW!$A$2:$A$27,B$1,RAW!$C$2:$C$27,$A2)
    Please Login or Register  to view this content.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    3,123

    Re: Stock Movement for too many stores ?

    HURRAY nflsales , i just moved to a new job and this company has 20 shops prior to my working at 5 shops

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Stock Movement daily vertical and horizontal
    By makinmomb in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-17-2015, 02:00 AM
  2. [SOLVED] No stock movement macro
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-10-2014, 08:15 AM
  3. 12 month stock movement ONE CLICK
    By makinmomb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2014, 10:20 AM
  4. Report stock movement report in excel 2007
    By sattarsiddiqui123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2014, 05:35 AM
  5. STOCK MOVEMENT day to day
    By makinmomb in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-10-2014, 12:34 PM
  6. Stock movement DAILY
    By makinmomb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2014, 06:08 AM
  7. [SOLVED] Stock movement columns monthly pulling
    By makinmomb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2014, 04:54 AM

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