Can anyone provide me the formula/s for below query? I have four columns. Company, Product, Date and Weight. What I need to do is add up the monthly volumes per Customer/Product for each month. I have over 170,000 records that I need to sort. I've tried multiple formulas but I can't seem to work it out.Please help!
Company Product Date Weight SHOULD EQUAL ABC OW 2006/07 0.2 0.2 ABC OW 2006/08 0.15 0.15 ABC OW 2006/09 0.2 - ABC OW 2006/09 0.1 0.3 ABC OC 2006/10 0.1 - ABC OC 2006/10 0.1 0.2 ABC OC 2006/11 0.3 0.3 ABC OC 2006/12 0.2 0.2 ABC OC 2007/01 0.1 - ABC OC 2007/01 0.2 0.3 ABC PL 2006/07 0.2 0.2 ABC PL 2006/08 0.2 0.2 ABC DD 2006/08 0.2 0.2 ABC PL 2007/04 0.2 - ABC PL 2007/04 0.15 0.35 ABC PL 2007/05 0.1 0.1 HEALTH OW 2007/05 0.2 0.2 HEALTH OW 2007/06 0.2 - HEALTH OW 2007/06 0.2 0.4 HEALTH OW 2007/07 0.2 - HEALTH OW 2007/07 0.1 0.3 HEALTH OW 2007/08 0.2 - HEALTH OW 2007/08 0.2 - HEALTH OW 2007/08 0.2 0.6 HEALTH OW 2007/09 0.2 0.2 HEALTH PL 2007/10 0.2 - HEALTH PL 2007/10 0.2 0.4 HEALTH PL 2007/11 0.3 - HEALTH PL 2007/11 0.2 0.5 DENTAL OC 2007/12 0.2 - DENTAL OC 2007/12 0.2 0.3 DENTAL OW 2008/01 0.15 0.15 DENTAL PL 2008/01 0.2 0.2 DENTAL DD 2008/02 0.1 - DENTAL DD 2008/02 0.2 0.3 DENTAL DD 2008/03 0.2 - DENTAL DD 2008/03 0.2 0.4 DENTAL DD 2008/04 0.1 0.1 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
