Hi Mr.Andy I appreciate your patience to explain in such a great depth of how to solve this problem. Fortunately i am using Office 2007 and the problem got solved in seconds....
I guess u have proficient knowledge about Excel formulas, Thanks to this group. Thank you very very very much Satish On Mon, Mar 30, 2009 at 3:06 PM, Aindril De <aind...@gmail.com> wrote: > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
