Hi Satish, If you are using office 2007 then you can easily use the COUNTIFS function: =COUNTIFS(A1:A23,"a",B1:B23,"c") will check how many "c" are there corresponding to "a", same thing can be done for "b" as well.
However if you are using Office 2003 or any lower version, then you have no option other than using the *SUMPRODUCT* function as the *COUNTIF *function does not support multiple criteria: =SUMPRODUCT(((A1:A23)="a")*((B1:B23)="c")*1) will check how many "c" are there corresponding to "a", same thing can be done for "b" as well. Hope it helps. Regards, Andy On Mon, Mar 30, 2009 at 2:13 PM, satish <satishpag...@gmail.com> wrote: > > Hello group member > > I need an help with respect to "Count-if Function". this is what my > query is > > say in "column A" there are many number of A, B, C (no any sequence) > etc in 1000 rows (one letter in each cell) > > Next, in "Column B" there are again many no. of A, B, C etc... > > I wanna know how many B's are there in "Column B" corresponding to A > in "column A" like wise how many C's in column B corresponding to A in > "column A" etc.. i should be able to find any kind of combination... > > If any one thinks they know the answer, Please share with this group. > > Regards > Satish > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
