In F2 I am using =SUM(IF(FREQUENCY(MATCH(Table1[Section],Table1[Section],0),MATCH(Table1[Section],Table1[Section],0))>0,1)) to tell me the Total number of Sections I have.
In F3 =COUNTIFS(Table1[Area],"*") to tell me the Total number of Areas I have.
In G3 =COUNTIFS(Table1[Area],"*",Table1[Finish],"*") tells me how many Areas are Finish.
I am trying to write a formula in G2 that will tell me how many Finish Sections there are.

I made a breakdown table below the count table and you can see there are 3 Sections that are done.

Attached Files

Check List.xlsx (9.7 KB, 19 views)