Why can't you use pivot table or subtotals commands instead of formulas Regards, Kishan Reddy, K.
On Jul 27, 10:29 am, "nkmorri...@hotmail.com" <nkmorri...@hotmail.com> wrote: > 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
