Count rows based on criteria in MS Excel


  • Hi All,

    I have an excel with following data in sheet 1

    I wanted to generate a report in sheet 2 with following data as shown below

    If  any one can help me on this, would be really great

    Thanks n Regards


    2012년 6월 9일 토요일 오후 3:30


  • In Sheet2, enter formulas as shown and copy across.

    Formulas are:

    For Total NCN (entered in cell B2)


    For Closed NCN (Entered in cell B3)


    Note that these refer to Cell B1 to obtain Department

    Ed Ferrero

    2012년 6월 10일 일요일 오전 7:10

모든 응답