Originally Posted by ArviLaanemets

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).

Originally Posted by ArviLaanemets

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.