Suksesmmh

 You can use the following formula in sheet2 to get the count of each projects listed in sheet1 =COUNTIF (Sheet1!BB,) Lets take a look of how to implement the above formula Lets say you have following data in your Sheet1Then click OK to close this dialog, and return to the worksheet, then type this formula =COUNTA (INDEX (CountSheets,0)) (CountSheets in this formula is the name you defined in step 3, you can change it as you need) into a blank cell, see screenshot 5 And press Enter key, you will get the number of your worksheets in the current workbookThe COUNTIF function is a builtin function in Excel that is categorized as a Statistical Function It can be used as a worksheet function (WS) in Excel As a worksheet function, the COUNTIF function can be entered as part of a formula in a cell of a worksheet If you wish to apply multiple criteria, try using the COUNTIFS function How To Handle Countif With Multiple Criteria In Excel Magoosh Excel Blog Countif formula in excel for blank cel...