We have an excel workbook, that we use to keep all our project evaluations. We work with multiple schools across London, each project in each school has its own worksheet that records basic data  number of children, sessions ect  – we  add new worksheets all the time.

We also have a summary sheet, where we add up all the totals from across all the project sheets –  How many Children have we worked with  XX  for example.

To do this we use  a simple    =sum(a:b!, b1) example.  Where the number of children is always in cell B1 on each project sheet.  And we use a blank ‘a’ tab and ‘b’ tab as parameters for the project worksheets – this easily allows us to add specific cells that are in between these two ‘a’ and ‘b’ tabs.

However, we also want to record the number of school projects that happen in different boroughs across London.

Brent, Newham, Camden, Barking, Tower Hamlets etc. we work in 12 boroughs… But as this is not number based we have to do a Count.

We always put the borough name in cell J1 on each project sheet.

On the summary sheet we want to have a list in column A of the 12 boroughs  from say A4 toA16  next to each of these names (in column B4-B16)  we would like to count the number of projects in each of the boroughs.

We have tried using countif   to do this but it does not work across multiple  and undefined worksheets.   I have been told the solution is  VB so I am asking if anyone could help me with the VB code to do this ?

Thank you in advance