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
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
SUMIF formula without the branch I know , I don't know to link the store into the sumif
B2=SUMPRODUCT((RAW!$A$2:$A$27=B$1)*(RAW!$C$2:$C$27=$A2)*(RAW!$I$2:$I$27))
Try this and copy acrossPlease Login or Register to view this content.
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.
HURRAY nflsales , i just moved to a new job and this company has 20 shops prior to my working at 5 shops
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks