Since you're using Excel2007, The simplest way (in my opinion) would be to use =countifs
in Cell F7 use: =COUNTIFS($A:$A,$E7,$C:$C,F$6) (if you use the "anchors" ($) properly, you'll be able to drag the formula across and down for other products) If you want more assistance with it, try using the function Wizard for CountIFs. Paul ________________________________ From: Kal xcel <kalx...@gmail.com> To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI <noorain.ans...@gmail.com>; davebonall...@hotmail.com; Dilip Pandey <dilipan...@gmail.com>; Bruno Bruno <brunobbr...@gmail.com>; C.G.Kumar <kumar.bemlmum...@gmail.com> Sent: Thu, January 6, 2011 6:59:36 AM Subject: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria Dear experts, I have attached a file with query. Please help on that Thanks in advance Kalyan -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
