For "Not Assigned" (section-2) is defined a name CntNA.



Just now I did find out, that formulas on sheet Report were faulty - the first check for all columns was against CntInProg, but must be against different name (CntInProg/CntPending/CntCompleted/CntNA) for different columns.

Btw, to make this solution really working one, you have to define dynamic named ranges for all columns of table on sheet 2017 referred to in formulas. And this particular solution is working for this particular setup (Which is from my point of view a very strange one! Can't field work be never completed or Section-2 be In Progress? When different statuses can be assigned to any column, the report will be expanding and formulas will be more complex).

And why has every project in table 2 rows? To put a big "X" into some columns? Without this all calculations would be much simpler. Even more - you could define table on sheet (2017) as a Table, and take the advantage of usage of Table formulas.

Yes.. All Status can be applied to all sections ie..(Field Work, Section-1, Section-2)
and yes it expands according to the number of project in the year 2017 or 2018

I was hoping to find a way for that.

I tried to apply it in the real Worksheet and I noticed the problem


I fixed that and applied at the way it should be